Why hide data?

Hiding columns or rows of data is a good way to keep other users of your worksheets focused on what you want them to see rather than on confidential or distracting information.

For example, suppose you have a worksheet that contains columns of formulas and data used in various calculations and a column with just the results of the calculations. To help users focus on just the results, you can hide the columns containing the formulas and other calculation data.

When you hide a column or row, the column letter or row number no longer appears in the worksheet frame.

Hidden column and row



Effects of hiding columns or rows



See also
Hiding columns or rows
Displaying hidden columns or rows
Hiding the worksheet gridlines
Protecting data
Sizing columns
Sizing rows