Borders, fill, alignment, Center Across Selection instead of Merge

In this lesson

1. 1. Bold headings

   Headings should stand out. Bold is the simplest way.

2. 2. A line under the headings

   A bottom border separates the headings from the numbers.

3. 3. A fill colour

   A light fill colour makes the heading row easy to find. Use light colours, so the text stays easy to read.

4. 4. Line up headings with numbers

   Numbers sit on the right. A heading above numbers should sit on the right too.

5. 5. Center a title without merging

   Merge joins cells into one. Merged cells can stop you from sorting or copying.

   Center Across Selection looks the same, but the cells stay separate.

6. 6. Try it yourself

   The title should stand out too.

Part of Excel Essentials. Short lessons with practice in a real spreadsheet, checked as you go.