Page 268 - Excel 2013 All-in-One For Dummies

250 Reorganizing the Workbook
2. Click the Format button on the Home tab and then highlight Tab Color, press Alt+HOT, or right-click the tab and then highlight Tab Color on the shortcut menu to display its pop-up color palette.
3. Click the color swatch in the color palette with the color and shade you want to assign to the current sheet tab.
To remove color-coding from a sheet tab, click the No Color option at the bottom of the pop-up color palette (Alt+HOT) after selecting it to make the worksheet active.
Assigning a graphic image as the sheet background
If coloring the sheet tabs isn’t enough for you, you can also assign a graphic image to be used as the background for all the cells in the entire worksheet. Just be aware that the background image must either be very light in color or use a greatly reduced opacity in order for your worksheet data to be read over the image. This probably makes most graphics that you have readily available unusable as worksheet background images. It can, however, be quite effective if you have a special corporate watermark graphic (as with the company’s logo at extremely low opacity) that adds just a hint of a back- ground without obscuring the data being presented in its cells.
To add a local graphic file as the background for your worksheet, take these steps:
1. Press Ctrl+PgDn until the sheet to which you want to assign the graphic as the background is active, or click its sheet tab if it’s dis- played at the bottom of the workbook window.
Don’t forget that you have to select and activate the sheet to which the graphic file will act as the background, or you end up assigning the file to whatever sheet happens to be current at the time you perform the fol- lowing steps.
2. Click the Background command button in the Page Setup group of the Page Layout tab or press Alt+PG.
Doing this opens the Insert Pictures dialog box, where you select the graphics file whose image is to become the worksheet background.
3. Click the Browse button to the right of the From a File link.
Excel opens the Sheet Background dialog box, where you select the file
containing the graphic image you want to use.
4. Open the folder that contains the image you want to use and then click its graphic file icon before you click the Insert button.
As soon as you click the Insert button, Excel closes the Sheet Background dialog box, and the image in the selected file becomes the background image for all cells in the current worksheet. (Usually,