10

Y O U R M I C R O S O F T O F F I C E T O O L S

C H A P T E R

Formatting cells

1Open the workbook you want to format.

2Highlight the cells you want to format.

3Press Menu (right action key) and select Format > Cells.

4Select any of the following:

Size: Sets the row height and column width.

Number: Sets the type of information the cells contain.

Align: Sets whether text wraps within the highlighted cells, and sets horizontal and vertical alignment position.

Font: Sets the typeface, color, size, and style attributes.

Borders: Turns borders on and off for various cell edges, and sets the border and background colors.

5Press OK .

TIP To name the highlighted cell or range of cells, press Menu and select Insert > Define Name. Enter the name and select Add. Press

OK.

Formatting rows and columns

1Open the workbook you want to format.

2Highlight the rows or columns you want to format.

3Press Menu (right action key), and then select Format > Row or Format > Column.

4Select any of the following:

AutoFit: Adjusts the size of the highlighted rows or columns to their contents.

Hide: Hides the highlighted rows or columns.

Unhide: Displays hidden rows or columns in the highlighted area.

DID YOU KNOW? You can adjust the column and row size by tapping and dragging the right edge of the column or the bottom edge of the row. 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.

Renaming a worksheet

1Open the workbook containing the worksheet you want to rename.

180E X C E L M O B I L E

Page 188
Image 188
Palm 750 manual Formatting cells, Formatting rows and columns, Renaming a worksheet