Filter
Top Products
300 Section 5B: Increasing Your Productivity
Formatting Rows and Columns
1. Open the workbook you want to format.
2. Highlight the rows or columns you want to format.
3. Press Menu (right softkey) and then select Format > Row or Format > Column.
4. Select any of the following:
Ⅲ AutoFit: Adjust the size of the highlighted rows or columns to their contents.
Ⅲ Hide: Hide the highlighted rows or columns.
Ⅲ Unhide: Display hidden rows or columns in the highlighted area.
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.
Did you know?
You can adjust the column or row size by tapping and dragging the right
edge of the column header or the bottom edge of the row header. To
automatically fit rows and columns to their contents, double-tap the lower
edge of the row heading or the right edge of the column heading.