Application Guide

306 Lists&Spreadsheet Application
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.
Filling Adjacent Cells
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.
Sharing a Cell Value as a Variable
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.