Microsoft Office Tutorials and References
In Depth Information
Hiding and unhiding a column follows the same process, except that you select the
worksheet column headings rather than the row headings. For example, to hide column B,
you select the column heading B. To unhide the column, you must select columns A and C.
On other occasions Joan would like to hide an entire worksheet. This could occur in sit-
uations where a worksheet contains detailed information and she only wants to display the
summary figures from another sheet. To show how to hide an entire worksheet, you should
suggest that she hide the documentation sheet located at the front of the workbook.
To hide the Documentation sheet:
1. Click the Documentation sheet tab to make it the active sheet.
2. Click Format on the menu bar, point to Sheet , and then click Hide .
The Documentation sheet disappears from the workbook. It is still present in the work-
book, it is just hidden at this point. Excel maintains a list of the hidden worksheets in the
current workbook, so you can always select one of those sheets to be redisplayed. Do this
now to unhide the Documentation sheet.
To unhide the Documentation sheet:
1. Click Format on the menu bar, point to Sheet , and then click Unhide . Excel displays the
Unhide dialog box, listing all hidden worksheets in the workbook.
2. Verify that Documentation is selected in the list of hidden worksheets, and click the OK button.
The Documentation sheet should be redisplayed in the workbook and made the active sheet.
3. Click the Sales sheet tab to return to the Sales worksheet.
Adding a Background Image
In the previous session you learned how to create a background color for individual cells
within the worksheet. Excel also allows you to use an image file as a background for a
worksheet. The image from the file is tiled repeatedly until the images fill up the entire
worksheet. Images can be used to give the background a textured appearance, like that of
granite, wood, or fibered paper. The background image does not affect the format or con-
tent of any cell in the worksheet, and if you have already defined a background color for a
cell, Excel displays the color on top, hiding that portion of the image.
Adding a Background Image to the Worksheet
Click Format on the menu bar, point to Sheet, and then click Background.
Locate the image file that you want tiled over the worksheet background.
Click the Insert button.