This two part tutorial on Microsoft Excel formatting covers a variety of formatting options that will help improve the look of your spreadsheets and make them easier to read.
Part 1 of this tutorial covers three areas of formatting available in Microsoft Excel:
- number formatting - using percent, comma, date, and currency formatting
- cell formatting
- text formatting
Part 2 of the tutorial covers changing the alignment of text in a cell. It also covers a number of other Excel features, that, while not formatting, they are commonly used features in Excel that will help to complete the spreadsheet:
- adding a range name
- adding a formula
- using the NOW function to include the current date on the spreadsheet
Shortcuts and Toolbars
The instructions for this tutorial make use of the options found in the Format Cells dialog box. Several of the steps in this tutorial, such as bolding data, can also be accomplished using toolbar buttons on the formatting toolbar or through shortcut keys on the keyboard. If you know these other options, feel free to use them.