Excel – hiding, unhiding and finding hidden Columns and Rows

You can easily hide rows and columns in Excel.  However sometimes it isn’t obvious where columns and rows have been hidden.

In this tutorial I show you how to hide and unhide columns and rows and how to easily locate where columns and rows have been hidden in a worksheet.

The following instruction applies to Excel 2007, 2010 and 2013.

Hiding rows and columns

To hide rows or columns select it and then right-click the selected area and select Hide.  It will be obvious the worksheet now contains hidden rows or columns as the column letters or row numbers will no longer be consecutive.

To unhide rows or columns select the columns or rows on either side of where it is hidden, right-click the selection and then select Unhide.


To quickly find hidden rows and columns

  1. To locate hidden rows or columns press F5 for Go To.
  2. Click Special, Visible cells only.
  3. Click OK.  Border lines will show where data is hidden.

If you found this post helpful please ‘Like’ us!