Computer and Business Skills training

Sign Up
Home / Excel / Hide and Unhiding

Hiding and Unhiding Rows and Columns in Excel


When you develop workbooks for others to use, it may be wise to restrict the access they have to certain cells, worksheets, or even the entire workbook. Some cells may contain formulas that you do not want changed, and certain workbooks may be confidential. You can hide columns and rows within a worksheet, as well as hide worksheets within a workbook. You can also password protect a workbook to restrict access to it.


For more details on our hands-on Excel training in Chicago and Los Angeles call us on 888.815.0604. All classes are taught by a live face-to-face trainer.


You might want to display or print a worksheet in such a way that some of the data is hidden, but not deleted from the workbook. You can hide rows or columns to conceal confidential or confusing data. The path the to the Hide/Unhide rows and columns is via the Cells group on the Home tab, using the Format button.



Visability > Hide & Unhide


Method to hide or unhide columns and rows

To hide a row:

  1. Select the row (or a cell in the row) you want to hide.
  2. On the Home tab, in the Cells group, click Format.
  3. In the Format submenu, click Hide & Unhide.
  4. Choose Hide Rows.

To hide a column:

  1. Select the column (or a cell in the column) you want to hide.
  2. On the Home tab, in the Cells group, click Format.
  3. In the Format submenu, click Hide & Unhide.
  4. Choose Hide Columns.

To unhide a row:

  1. Select the rows (or cells in the rows) above and below the hidden row.
  2. On the Home tab, in the Cells group, click Format.
  3. In the Format submenu, click Hide & Unhide.
  4. Choose Unhide Rows.

To unhide a column:

  1. Select the columns (or cells in the columns) to the left and right of the hidden column.
  2. On the Home tab, in the Cells group, click Format.
  3. In the Format submenu, click Hide & Unhide.
  4. Choose Unhide Columns.

Also see using Data validation in Excel.


Onsite Excel training

Through our network of expert trainers we deliver onsite Microsoft Excel training right across the country. View our Excel training testimonials or obtain a quote for an onsite Excel class.


Excel courses

Why train with us?Need Group training quotation?Fresh Starbucks brewed every day Book two levels of Excel training and save $100FREE Class Repeat with each courseBook 3 Level of Excel Training and save $150