About this lesson
Format cells by selecting fonts and color fills to make information more attractive.
Multiple versions of this lesson are available, choose the appropriate version for you:
Download the ‘before’ and ‘after’ Excel workbooks from the video tutorial and try the lesson yourself.Formatting.xlsx
18.1 KB Formatting - Completed.xlsx
Excel formatting basics.
When to use
Making information look more attractive in Excel.
General formatting notes
- Cells can be formatted individually or as a group (when multiple cells are selected before formats are applied)
- Many formatting changes support “Live Preview” which shows you what the formatting will look like in the grid as you mouse over the formats (you don’t have to commit them to see the effects.)
Quick Access Formats
- Fonts and their associated properties (size, color, bold, underline, etc) can be achieved by using the commands on the Home tab’s Font group
- Cell borders and color fills can also be applied via the commands on the Home tab’s Font group
- Alignment of cell contents can be achieved by using the commands on the Home tab’s Alignment group
- Common number formats can be applied via the Home tab’s Number group
Advanced Cell Formatting
- Accessed by right clicking on a cell and choosing “Format Cells”
- The Format Cells dialog contains all formatting options available to the selected cell(s), including many that are not available through Ribbon commands.
Lesson notes are only available for subscribers.