Useful Formatting Tools

Center Across Selection Instead of Merge

To center text or values on your report, use Center Across Selection from Format Cells Alignment Options instead of Merging. This makes it easier to write formulas, copy specific columns & maintain the report.

Fill > Justify

To fit long text or set of instructions to a specific number of cells in a column, select the range, go to Home > Fill > Justify.

Number Formatting Options

Take advantage of the various number formatting options available under Format Cells (Ctrl+1). For example, use Special Formatting to format phone numbers properly.

Conditional Formatting

Create Conditional Formatting Rules to highlight specific cells or use it to add dynamic icons and data bars to your reports. You have some good built-in options there, such as Top 10%, Above or Below Average etc...

Remember: Your downloadable course notes cover the most important points. Make sure you keep them handy.

Here's how far you've come

Keep Going!