Apply and Modify Cell Formats

Apply and Modify Cell Formats

You can use the Format Cells window to apply the following cell formatting to cells and worksheets:

• Leaders between words and values
• Number format
• Alignment of the cell or table in the object (left, center, or right)
• Font format
• Borders around rows, columns, and cells
• Patterns in the cell
• Protection to prevent cells from being edited

Formatting Toolbar

The contents of a highlighted cell can be formatted in many ways. Font and cell attributes can be added from shortcut buttons on the formatting bar. If this toolbar is not already visible on the screen, select View > Toolbars > Formatting from the menu bar.

Format Cells Dialog Box

For a complete list of formatting options, right-click on the highlighted cells and choose Format Cells from the shortcut menu or select Format > Cells from the menu bar.