Add Borders

Borders above and below the totals and net amounts would really help them stand out. We'll add single lines above and below Income and Expense totals and a double line beneath the Net Income amounts.

Select cells B6 to E6, and B27 to E27. Remember, you must hold down the Control (Windows) or Command (Mac OS) key to select multiple ranges.

In Windows:

Click the triangle on the Borders button on the Formatting toolbar ...

Get Creating Spreadsheets and Charts in Excel: Visual QuickProject Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.