Change Text Color

When we applied a dark border to the worksheet's headings, we created a problem: The black text may not be legible with the dark cell shading. We can fix this problem by making the heading text a lighter color.

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 Font Color button on ...

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.