Excel4Business - Our Blog

Excel Tips and Tricks from our Experts

Excel Help - How to Hide and Unhide Rows and Columns in Excel

In this video you’ll learn how to hide rows and columns in Excel and then display them when you need them. Hiding and unhiding are useful functions when you would like to hide certain information for displaying or printing and then restore it when necessary.

Start by selecting the rows or columns that you would like to hide.

Go to the Home tab, find the Cells group, and click Format.

Find Visibility, select Hide & Unhide, and click Hide Rows or Hide Columns.

To display a hidden row, select the row above and below the row or rows that you would like to unhide.

If you want to display a hidden column, select a column to the right or left to the column or columns that you want to unhide.

Go back to the Home tab, find the Cells group, click Format, select Visibility, choose Hide & Unhide, and click Unhide Rows or Unhide Columns.