Texas Instruments NS/CLM/1L1/B User Guide - Page 111

Working with rows and columns of data, Selecting a row or column, Inserting an empty row or column

Page 111 highlights

4. Press ¤ repeatedly to move down, selecting the range of cells that will hold the repetitions. 5. Press ·. The selected cell is duplicated throughout the selected range. Notes • 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. Working with rows and columns of data Selecting a row or column f Move to the top of the column, and then press £. - or - Move to the leftmost cell of the row, and then press ¡. Resizing a row or column 1. Select the row or column that you want to resize. 2. Press b to display the Lists & Spreadsheet menu. 3. On the Actions menu, select Resize. 4. Use ¡ and ¢ to resize the column, or use £ and ¤ to resize the row. 5. Press ·. Inserting an empty row or column 1. Select the column or row where you want to insert the new data. 2. Press b to display the Lists & Spreadsheet menu. 3. On the Insert menu, select either Row or Column. - If you are inserting a row, the remaining rows shift down to create space for the new row. - If you are inserting a column, the remaining columns shift right to create space. Note: If other cells contain formulas with relative references to a displaced row or column, those references adjust accordingly. Using Lists & Spreadsheet 103

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75
  • 76
  • 77
  • 78
  • 79
  • 80
  • 81
  • 82
  • 83
  • 84
  • 85
  • 86
  • 87
  • 88
  • 89
  • 90
  • 91
  • 92
  • 93
  • 94
  • 95
  • 96
  • 97
  • 98
  • 99
  • 100
  • 101
  • 102
  • 103
  • 104
  • 105
  • 106
  • 107
  • 108
  • 109
  • 110
  • 111
  • 112
  • 113
  • 114
  • 115
  • 116
  • 117
  • 118
  • 119
  • 120
  • 121
  • 122
  • 123
  • 124
  • 125
  • 126
  • 127
  • 128
  • 129
  • 130
  • 131
  • 132
  • 133
  • 134
  • 135
  • 136
  • 137
  • 138
  • 139
  • 140
  • 141
  • 142
  • 143
  • 144

Using Lists & Spreadsheet
103
4.
Press
¤
repeatedly to move down, selecting the range of cells that
will hold the repetitions.
5.
Press
·
.
The selected cell is duplicated throughout the selected range.
Notes
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.
Working with rows and columns of data
Selecting a row or column
Move to the top of the column, and then press
£
.
– or –
Move to the leftmost cell of the row, and then press
¡
.
Resizing a row or column
1.
Select the row or column that you want to resize.
2.
Press
b
to display the Lists & Spreadsheet menu.
3.
On the
Actions
menu, select
Resize
.
4.
Use
¡
and
¢
to resize the column, or use
£
and
¤
to resize the row.
5.
Press
·
.
Inserting an empty row or column
1.
Select the column or row where you want to insert the new data.
2.
Press
b
to display the Lists & Spreadsheet menu.
3.
On the
Insert
menu, select either
Row
or
Column
.
If you are inserting a row, the remaining rows shift down to
create space for the new row.
If you are inserting a column, the remaining columns shift right
to create space.
Note:
If other cells contain formulas with relative references to a
displaced row or column, those references adjust accordingly.