Excel Tip: How to locate hidden cells on a worksheet

Posted by EQ Tech on Fri, Jan 30, 2015

When you want to print certain rows/columns of data in a worksheet, you will most likely hide the other rows/columns, however when you want to unhide cells in hidden rows/columns it can be hard to locate them. By selecting all visible cells in the worksheet, you can easily detect the hidden rows/columns, as they will be highlighted in white and thus can be easily located.

Note: Download the sample workbook to practice this exercise.

Applies to: Microsoft® Excel® 2007, 2010 and 2013

Rows 4, 5, 12 and 13 are hidden in the sample worksheet shown below.1 20 2014 11 54 19 AM

1. To select visible cells on the worksheet/s, Press Alt + ; or follow the steps below:

a)     On the Home tab, in the Editing group, select Find & Select.

1 20 2014 11 55 18 AM

2. Select Go To Special.

1 20 2014 11 56 16 AM

3. Under Select, click Visible cells only, and then click OK.

1 20 2014 11 58 08 AM

All visible cells are selected and the borders of rows and columns that are adjacent to hidden rows and columns are marked with a white border.

1 20 2014 11 58 51 AM

Note: Clicking anywhere on the worksheet will cancel the selection of the visible cells. If the hidden cells that you want to unhide are outside of the visible worksheet area, use the scroll bars to move through the document until the hidden rows and columns that contain those cells are visible.

Submit a Comment

Need Help Now?

Request a Call