Hiding and unhiding rows and columns is a straightforward and easy task, unless you’re trying to unhide row 1 or column A. When unhiding a row or column, you select the adjacent rows or columns, but there’s no row above row 1 or column to the left of column A, which presents a bit of a conundrum. Today, I’ll show you how to unhide row 1 and column A.
First, let’s run through the instructions for hiding and unhiding rows and columns, just in case this task is new to you. To hide a row or column, you click the header to select the entire row or column, right-click the selection, and choose Hide from the resulting context menu. To hide multiple noncontiguous rows or columns, select the rows or columns and choose Hide & Unhide from the Format dropdown in the Cells group. In Excel 2003, choose Column or Row from the Format menu, and then select Hide.
You can quickly discern that a row or column is hidden by the missing header. Unhiding is also simple. Select the adjacent columns or rows, right-click, and select Unhide from the resulting context menu. In the sheet below, I selected columns C and E to unhide column D. Use the same process to unhide multiple non-contiguous rows and columns as you would a single row or column, just select a larger range.
It’s a simple task, but a problem arises when you want to unhide row 1 or column A because there’s no row or column above or to the left, respectively.
When row 1 or column A is hidden, enter A1 in the Name Box, and press Enter. Excel will select cell A1, but you won’t see that happen, because the cell’s hidden. Next, click the Format dropdown in the Cells group (on the Home tab) and choose Hide & Unhide. Then, select Unhide and Excel will expose the hidden row or column. In Excel 2003, use the Name Box to select cell A1. Then, choose Row or Column from the Format menu, and select Unhide.
There are a couple of tricks for unhiding, but I’ve found most users forget them because they don’t use them often enough to commit them to memory. This technique seems easy for most users to remember. What’s your favorite trick for unhiding row 1 or column A?
Subscribe to the Developer Insider Newsletter
From the hottest programming languages to commentary on the Linux OS, get the developer and open source news and tips you need to know. Delivered Tuesdays and Thursdays