Microsoft Office Tutorials and References
In Depth Information
Managing Worksheet Views
To hide rows or columns, select the rows or
columns to hide by dragging over their row or
column labels. For example, to hide rows 11–13,
drag over the row labels 11, 12, and 13 to select
those rows. Then click the Format button on the
Home tab and point to Hide & Unhide from the
pop-up menu. Another pop-up menu appears;
select Hide Rows or Hide Columns, depending
on what you are trying to hide. As an alternative,
you can right-click the selected rows/columns
and choose Hide from the pop-up menu.
Hiding a Row Doesn’t
Make It Secure
Hiding rows and columns is not about
securing data—in other words, preventing it from
being seen by spying eyes. However, you can
hide a worksheet or workbook to prevent its
data from being seen—see Chapter 13,
“Setting Security Options” for help.
Hiding rows or columns does not delete the data
in them, so don’t worry about that. When a row
or column is hidden, it’s pretty obvious because
the row number or column letter is missing from
the top or left of the Excel window. For example,
if you hide row 23, you’ll see the row numbers
21, 22, and 24 on the left side, but not 23.
You can also hide the contents of an
individual cell if you feel like it. If a cell’s
contents are hidden, it simply appears
empty. However, if someone clicks the cell,
its contents are displayed in the Formula
bar. The idea is that someone would need
to know to click the cell, and for the
most part, if a cell appears empty, they
probably won’t. To hide the contents of
a cell, click it, and click the Dialog Box
Launcher in the Number group on the
Home tab. The Format Cells dialog box
appears with the Number tab displayed
because you are going to apply a custom
number format that makes the cell
contents disappear. Select Custom from
the Category list. In the Type box on the
right, type three semicolons (;;;). The
Sample will show nothing, because the
effect of this format is hiding the data.
Click OK, and the cell’s contents are
hidden. Repeat this process to hide the
data in other cells.
The same is true of columns—if you hide
columns C-E, you’ll see the letters A, B, F, and G
across the top, as shown in Figure 6-33.
The column labels for hidden columns may
call attention to the fact that they are hidden.