Apply Shading

Shading can also improve the appearance of a worksheet. We'll apply dark colored shading to worksheet cells containing headings so they really stand out, then apply a lighter color shading to the rest of the worksheet.

Select cells A1 to E1 and A2 to A28. Remember, you must hold down the Control (Windows) or Command (Mac OS) key to select multiple ranges.

In Windows, click the triangle on the Fill 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.