HTC S730 User Manual - Page 170

Menu > Edit > Define Name, Menu > Tools > Go

Page 170 highlights

170 Using Other Applications To edit the cell range of a defined name If your worksheet contains defined names created in Microsoft Excel on the PC, you can edit the cell range of the defined name. 1. Click Menu > Edit > Define Name. 2. In Range Name, select the name whose cell range you want to change. 3. In Refers to, type in the new cell range. 4. Click Done. To delete cells • Select the cell you want to delete and click Menu > Edit > Delete Cells. Tip You can select multiple cells to delete by clicking Menu > Select and then choosing what to select in the worksheet. To copy and paste cell contents 1. Select the cell(s) you want to copy and then click Menu > Edit > Copy. 2. Select the cell(s) where you want to copy the cell contents to and click Menu > Edit > Paste. To insert a row or column Select the cell where you want to insert a row or column and then click Menu > Insert > Row or Column. If you insert a row, the row will be inserted above the selected cell; if you insert a column, the column will be inserted at the left of the selected cell. Tip You can also shift the contents of a row or column. To shift, select the cell you want to shift and click Menu > Insert > Shift Right or Shift Down. To go to a cell • Click Menu > Tools > Go To and then enter the Cell reference or name. Click OK. Tip You can also sort and find text in the worksheet by clicking Menu > Tools > Sort or Find.

  • 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
  • 145
  • 146
  • 147
  • 148
  • 149
  • 150
  • 151
  • 152
  • 153
  • 154
  • 155
  • 156
  • 157
  • 158
  • 159
  • 160
  • 161
  • 162
  • 163
  • 164
  • 165
  • 166
  • 167
  • 168
  • 169
  • 170
  • 171
  • 172
  • 173
  • 174
  • 175
  • 176
  • 177
  • 178
  • 179
  • 180
  • 181
  • 182
  • 183
  • 184
  • 185
  • 186
  • 187
  • 188
  • 189
  • 190
  • 191
  • 192

170 Using Other Applications
To edit the cell range of a defined name
If your worksheet contains defined names created in Microsoft Excel on the
PC, you can edit the cell range of the defined name.
1.
Click
Menu > Edit > Define Name
.
2.
In
Range Name
, select the name whose cell range you want to
change.
3.
In
Refers to
, type in the new cell range.
4.
Click
Done
.
To delete cells
Select the cell you want to delete and click
Menu > Edit > Delete
Cells
.
Tip
You can select multiple cells to delete by clicking
Menu > Select
and then
choosing what to select in the worksheet.
To copy and paste cell contents
1.
Select the cell(s) you want to copy and then click
Menu > Edit >
Copy
.
2.
Select the cell(s) where you want to copy the cell contents to and click
Menu > Edit > Paste
.
To insert a row or column
Select the cell where you want to insert a row or column and then click
Menu > Insert > Row
or
Column
. If you insert a row, the row will be
inserted above the selected cell; if you insert a column, the column will be
inserted at the left of the selected cell.
Tip
You can also shift the contents of a row or column. To shift, select the cell you
want to shift and click
Menu > Insert > Shift Right
or
Shift Down
.
To go to a cell
Click
Menu > Tools > Go To
and then enter the Cell reference or
name. Click
OK
.
Tip
You can also sort and find text in the worksheet by clicking
Menu > Tools >
Sort
or
Find
.