Back to Help with TI-Nspire
Filling adjacent cells
You can repeat a cell's formula or value throughout adjacent cells. This gives you a quick way to fill cells with the same value or create a series of cells that contain the same formula. You can fill down within a column. To do this:
- Select the cell whose value or formula you want to repeat.
- Press menu to display the Lists & Spreadsheet menu.
- On the Data menu, select Fill Down.
- Press
repeatedly to move down, selecting the range of cells that will hold the repetitions. - Press enter.
The selected cell is duplicated throughout the selected range. Please note:
- In step 1, you can select more than one cell to be repeated.
If you do, make sure that you select enough destination cells to hold the repeated copies.
- If you select multiple cells in step 1 and the cells contain a simple sequence (such as 1,2,3 or 5,10,15,20), the sequence is continued in the filled area.
Follow along with this example for filling adjacent cells:
- To create a 10 item list of numbers increasing by 5 starting at 0, type 0 into cell a1 and type "= a2 + 5" into cell a2 and press enter.
- Select cell a2.
- Press menu to display the Lists & Spreadsheet menu.
- On the Data menu, select Fill Down.
- Click a2 and scroll down to a10.
