Filter
Top Products
Copyright © 2004 Nokia. All rights reserved.
Office
146
To select cells
There are two ways to select a cell or a range of cells in a worksheet:
Example: To select column A, enter A:A. To select row 1, enter 1:1. To select
columns B and C as well as rows 2 and 3, enter B2:C3
• Press the Menu key and select Edit > Select. Then enter the selection range or
choose a range from the list.
• Press and hold the Shift key, and increase the selection frame with the Arrows
key.
To select entire rows or columns, press and hold the Shift key, and select the desired
row or column headings with the Arrows key.
To select the entire worksheet, use the shortcut Ctrl + A.
The selection is cleared when you press the Arrows key or Tab key.
To insert cells
1 Select a number of cell(s) that you want to insert into the worksheet.
2 Press the Menu key and select Insert > Cells. A dialog opens.
3 Define whether you want the inserted cell or cells to appear above (Shift cells
down) or left (Shift cells right) of the selected range.
To insert an entire row(s) or column(s), select either Entire row or Entire column.
4 Press OK to accept the insertion and Cancel to dismiss it.
To sort cells
You can rearrange the order of cells from top to bottom and left to right.
1 Select the range.
2 Press the Menu key and select Tools > Sort.
3 Then select either Top to bottom or Left to right. A dialog with the relevant number
of pages opens.
4 Define the sorting criteria.
5 Press Close to do the sorting.
To search for data
1 Press the Menu key and select Edit > Find. A dialog opens.
2 In the Find: field, enter the string you want to search for.
Tip: Pressing Options opens up the following options: Search in values, Search in
formulae, Match case, Find entire cells only, Direction, and Search by.
3 Press Find to search for the string.
Press Options to search the worksheet according to certain criteria.
LindaDeepak_ri.fm Page 146 Monday, September 27, 2004 2:34 PM