Section 5B: Increasing Your Productivity 245
Productivity
Renaming a Worksheet
1. Open the workbook containing the worksheet you want to rename.
2. Press Menu (right softkey) and select Format > Modify Sheets.
3. In the Sheets list, highlight the worksheet you want to rename.
4. Select Rename, enter a new name for the worksheet, and then press OK
twice.
Sorting Information in a Worksheet
1. Highlight the cells you want to sort.
2. Press Menu (right softkey) and select Tools > Sort.
3. Select the Sort by list, and then select the primary sort column.
4. Check or uncheck the Ascending box to indicate whether you want to sort in
ascending or descending order.
5. (Optional) Select the Then by lists, and then select second and third level
sorting options.
6. Check or uncheck the Exclude header row from sort box to indicate if you
want to sort the header row.
7. Select OK.
Filtering Information in a Worksheet
1. Highlight the cells that contain the information you want to filter.
2. Press Menu (right softkey) and select Tools > AutoFilter.
(A list appears at the top of each related column).
To Next Page
Loading...
