You'll want to apply color to attract attention to specific areas of a sheet and to identify purpose, category, and other important specifications. Used discretely and with specific intent, color can guide users through their work and help them work more efficiently. These three tips are easy ways to consider color when working with Excel sheets.
Adding descriptive text to sheet tabs is usually enough, but sometimes a bit of color can help - especially if your org already has a set of conventions that utilize color. To add color to a tab, do the following:
- Right-click the tab and choose Tab Color.
- Select a color from the resulting palette. If you're using Excel 2003, click OK.
- Move to another sheet and watch as Excel colors the tab.
Change gridline color
Gridlines are the cell outlines that you see on screen. They don't print (by default) and they're not the same as borders. You can turn them off for individual sheets by clicking the View tab and unchecking Gridlines in the Show group. In Excel 2003, choose Options from the Tools menu, then, click the View tab and uncheck Gridlines in the Window Options section. Besides turning the display off and on, you can also change their color, as follows:
- Click the File tab and choose Options in the left pane (under Help). In Excel 2007, click the Office button and then click Word Options. In Excel 2003, choose Options from the Tools menu.
- In the left pane, select Advanced. In Excel 2003, click the View tab.
- In the Display Options For This Worksheet section, choose a color from the Gridline Color dropdown. (Automatic is the default setting.)
- Click OK.
If you want to print gridlines, use the Page Setup dialog in the Backstage (File tab or Office button). Click the Sheet tab and check Gridlines in the Print section.
Printing in black and white
While we're discussing colors and printing, you might want to know that you don’t have to print your sheets in color. In fact, unless you have a specific reason to do so, printing all those colors is expensive. To print a colorful sheet in black and white, do the following:
- Click the File tab or Office button. In Excel 2003, choose Page Setup from the File menu and skip to step 4.
- Choose Print from the left pane.
- At the bottom of the print options, click the Page Setup link.
- Click Options in the resulting dialog.
- On the Paper Quality tab, click the Black & White option in the Print section.
- Click OK twice and click the Home tab to return to your sheet.
Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals.