Excel Guides

How to use Non-Printing Controls in Excel

There are many ways to use non-printing controls in Excel. Here are some tips:

  1. To hide a column, select the column header and then click on the Hide button in the Home tab.
  2. To unhide a column, select the adjacent columns on either side of the hidden column and then click on the Unhide button in the Home tab.
  3. To hide a row, select the row header and then click on the Hide button in the Home tab.
  4. To unhide a row, select the adjacent rows on either side of the hidden row and then click on the Unhide button in the Home tab.
  5. To hide cells, select the cells that you want to hide and then click on the Format button in the Home tab. In the Format Cells dialog box, go to the Protection tab and check the Hidden checkbox.
  6. To unhide cells, select the cells that you want to unhide and then click on the Format button in the Home tab. In the Format Cells dialog box, go to the Protection tab and uncheck the Hidden checkbox.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.