The Lists & Spreadsheet application displays black text and cells with a white background by default. You can change the color of cells and text to emphasize or distinguish data. The colors and the order in which color is assigned is based on the TI‑Nspire™ color palette.
1. | Select the cells to fill with color. You can choose one or more cells in any adjacent cells, columns, or rows. |
2. | Access the context menu and click Color > Fill Color. |
3. | Click the color to apply to the cells. |
Note: If you combine color text and color cells, choose colors carefully to ensure visibility as you work with documents in the software and on the handheld.
1. | Select the cells that contain the text to change. You can choose one or more cells in any adjacent cells, columns, or rows. |
2. | Access the context menu and click Color > Text Color. |
3. | Click the color to apply to the text. Empty cells in the selection area show the color change when text is added. |
Use a cell reference to use data from a cell or range of cells in a formula. The calculation results update automatically when values in cells change.
Relative references include only the cell’s column letter and row number (for example, E7). A relative reference describes where a cell is in relation to other cells of the spreadsheet. The Lists & Spreadsheet application keeps track of relative cell references and adjusts the reference automatically when surrounding cells shift (because of actions you perform, such as column deletions or cell insertions).
Follow these guidelines to specify cell references:
• | Include a column letter and row number in a relative reference. |
• | Include the $ symbol before both the column letter and the row number to specify an absolute reference. |
• | Include a colon (:) between a two cell reference to specify a range of cells. |
Absolute references include the $ symbol before the column letter and before the row number (for example, $B$16). Absolute references always refer to the cell in a specific position in the spreadsheet. The application does not automatically adjust the cell reference when cell positions change.
1. | Double-click the cell and type the formula. For more information, see the Calculator section. |
2. | Move to the appropriate position in the formula and type the cell reference. Use the format for a relative reference (B3), absolute reference ($B$2), or range of cells (A1:A4). |
Note: You can click Recalculate on the Actions menu to update all references and formula results in a spreadsheet.
1. | Click a cell to select it. |
—or—
Use the arrow keys to move to the cell.
Note: If you are deleting a range of cells, select a cell at one end or corner of the range, and then use Shift with the arrow keys to select the remaining cells in the range.
2. | Press Del. |
Note: Any cell that uses a formula with an absolute reference to deleted data shows an error. A cell that uses a formula with a relative reference to deleted data is updated to use the data currently in the referenced position.
When you copy cells, any formulas in the original cells are copied to the destination cells.
1. | Click the cell to copy. |
—or—
Use the arrow keys to move to the cell.
Note: If you are copying a range of cells, select a cell at one end or corner of the range, and then use Shift with the arrow keys to select the remaining cells in the range.
2. | Use the standard key shortcut for copying a selection. |
Windows®: Press Ctrl+C.
Mac®: Press “+C.
Handheld: Press / C.
3. | Click the cell where you want to duplicate the copied cell. If you are copying a block of data, click the cell that will become the upper left corner of the copied block. |
4. | Paste the selected cells: |
Windows®: Press Ctrl+V.
Mac®: Press “+V.
Handheld: Press / V.
Important: Paste copied data into a cell that is in the same mode as the cell from which the data was originally copied. Otherwise, a formula could paste as a string enclosed in quotes instead of a formula.
You can repeat a cell’s formula or value throughout adjacent cells within the row or column. You can also repeat a range of cells horizontally or vertically. If you fill from a range that contains a simple sequence (such as 2, 4, 6), the sequence continues in the filled cells.
1. | Click the cell that contains the value or formula to repeat. |
Note: If you are repeating a range of cells, drag to select the range, or select a cell at one end of the range, and then use Shift with the arrow keys to select the remaining cells.
2. | Click Data > Fill. |
3. | Use the arrow keys, or drag to select the range that will hold the repetitions. |
4. | Press Enter. |
The value, formula, or pattern that you selected for duplication is repeated over the selected range.
You can share the value of a cell with other TI‑Nspire™ applications by storing it as a variable. When you define or refer to a shared cell or variable in Lists & Spreadsheet, the name is preceded with an apostrophe (‘).
1. | Click the cell that you want to share. |
2. | Click on the toolbar, and click Store Var to store the cell’s value. |
Handheld: Press / h or press h and select Store Var).
A formula is inserted into the cell with var as a placeholder for a variable name.
3. | Type over the letters “var” with a name for the variable, and press Enter. Use a variable name that does not exist in the current problem. |
The value is shown in bold to indicate that it is now available as a variable to other TI‑Nspire™ applications.
When you link a cell to a variable, Lists & Spreadsheet keeps the cell value updated to reflect the current value of the variable. The variable can be any variable in the current problem and can be defined in Graphs & Geometry, Calculator, Data & Statistics, or any instance of Lists & Spreadsheet.
1. | Click the cell that you want to link to a variable. |
2. | Click on the toolbar, and click Link to. |
Handheld: Press / h or press h and select Link to.
The VarLink menu opens.
3. | Under Link To, press ▲, and ▼ to scroll to the name of the variable. |
4. | Press Enter. |
The cell shows the value of the variable.
Note: Use caution if you link to a system variable. Linking could prevent the variable from being updated by the system. System variables include statistics results (such as Stat.RegEqn, Stat.dfError, and Stat.Resid) and finance-solver variables (such as tvm.n, tvm.pmt, and tvm.fv).