This free 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.
Tutorial Topics
Part 1 of this tutorial covered number formatting and formatting cell color.
Part 2 of this tutorial covers changing text alignment as well as several other commonly used Excel features 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 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.
Entering the Data
Instructions for entering the data, including cell references, are available at the end of Part 1 of this tutorial.
