Hide columns in Excel 2007

You can hide columns that do not want to be visible. For example, the column(s) have sensitive data or formulas. One more use of hiding the column(s) is that the information in the hidden column(s) does not get printed. You can hide a single column or multiple columns.
Regarding hiding multiple columns, the columns can be adjacent to each other (for example, hiding columns C, D, E, and F) or you can hide nonadjacent columns (for example, hiding columns D, H, and K or D, E, H, and K). There are several ways to hide column(s) in Excel 2007.
Perform the following to hide column(s):
A. Right click on a column header and from the menu that appears, click Hide.
B. For hiding multiple columns that are adjacent to each other, click the first column header and then press the Shift key. Keeping the Shift key in pressed state, click to select the last column header and then right click on any selected column header and from the menu that appears, click Hide.
C. For hiding nonadjacent columns, click on the first column header and then press the Ctrl key. Keeping the Ctrl key in pressed state, click to select other columns. Once the selection is over, right click on any selected column header and click Hide.

You can also hide column(s) by clicking on any cell in that particular column and then clicking the Home tab, in the Cells group, click Format, point to Hide and Unhide and click Hide Columns. The keyboard equivalent for this is Alt + H + O + U + C (Alt H O U C).

You can also hide column(s) by setting the width of the column to zero. Right click on a column header and click Column Width... From the Column Width dialog box that appears, enter 0 and then click OK.

The quickest way to hide a column is using the keyboard shortcut Ctrl + 0 (Zero).