Please Note: This article is written for users of the following Microsoft Excel versions: 2007, 2010, and 2013. If you are using an earlier version (Excel 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Excel, click here: Displaying a Hidden First Row.

Displaying a Hidden First Row

Written by Allen Wyatt (last updated August 14, 2018)
This tip applies to Excel 2007, 2010, and 2013


Excel makes it easy to hide and unhide rows using the menus. What isn't so easy is displaying a hidden row if that row is above the first visible row in the worksheet. For instance, if you hide rows 1 through 5, Excel will dutifully follow out your instructions. If you later want to unhide any of these rows, the solution isn't so obvious.

To unhide the top rows of a worksheet when they are hidden, follow these steps:

  1. Press F5. Excel displays the Go To dialog box. (See Figure 1.)
  2. Figure 1. The Go To dialog box.

  3. In the Reference field at the bottom of the dialog box, enter the number of the row range that you want to unhide. For instance, if you want to unhide rows 2 through 3, enter 2:3. Likewise, if you want to unhide row 1, enter 1:1.
  4. Click on OK. The rows you specified are now selected, even though you cannot see it on the screen.
  5. Display the Home tab of the ribbon.
  6. In the Cells group click the Format tool.
  7. Hover the mouse pointer over the Hide & Unhide option and then click Unhide Rows.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (11104) applies to Microsoft Excel 2007, 2010, and 2013. You can find a version of this tip for the older menu interface of Excel here: Displaying a Hidden First Row.

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He is president of Sharon Parq Associates, a computer and publishing services company. ...


Tracing Dependent Cells

Cells that use the information in a particular cell are called dependent cells. Excel provides auditing tools that allow ...

Discover More

Understanding Underlines

Excel provides a variety of underlining styles you can use when you need to underline information within a cell. Here's ...

Discover More

Faster Text File Conversions

Want to make your importing of text data faster than ever? Here are some ideas you can apply right away.

Discover More

Professional Development Guidance! Four world-class developers offer start-to-finish guidance for building powerful, robust, and secure applications with Excel. The authors show how to consistently make the right design decisions and make the most of Excel's powerful features. Check out Professional Excel Development today!

More ExcelTips (ribbon)

Copying from the Task Bar

When you select cells in a worksheet, there is a good chance that if you glance at the Task Bar, you'll see some ...

Discover More

Viewing Your Work Full-Screen

Want to use the maximum space possible for displaying information on screen? You'll want to learn how to use the ...

Discover More

Deleting Duplicate Columns

Have a worksheet in which there may be entire columns that are duplicates of each other? If you want to delete those ...

Discover More

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

View most recent newsletter.


If you would like to add an image to your comment (not an avatar, but an image to help in making the point of your comment), include the characters [{fig}] (all 7 characters, in the sequence shown) in your comment text. You’ll be prompted to upload your image when you submit the comment. Maximum image size is 6Mpixels. Images larger than 600px wide or 1000px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted.

What is two more than 0?

2018-08-20 18:17:00

Bill Woolfolk

A faster albeit less prcise way to unhide those rows at the top of the sheet is to click and hold on the row header for the first visible row and drag up to the Select Sheet button in the corner and let go the mouse. Then, right-click on the selected visible row header and choose Unhide.

2018-08-15 07:37:08


How actually check if I ,manually by clicking, unhide all rows in sheet?
As part of solution another question :why when in sheet some rows hidden-- excel by default not give you visual
indication in area of row numbers about hidden cells ?

2018-08-14 08:29:53

Alan Cannon

I have an easier way to unhide row 1. The downside though is that it will unhide every hidden row on the entire sheet. To do this, click the square area above the row #'s and left of the column letters. This selects the entire worksheet. Now right-click any visible row # and choose unhide from the context menu. Done!

2018-08-14 08:25:19


Alternatively, click on the first row visible and while holding down the left mouse button drag the mouse all the way to the top left corner of the spreadsheet. This has the affect if highlighting the hidden row(s). Now right mouse and click on unhide.

2018-08-14 05:59:17

Dave Roberts

Alternatively - (in Excel, never!) - in the name box, you can type "1:3" (without the quotes), press Enter and then press Ctrl-Shift-9.

2016-11-30 15:47:47


Thank you so much for posting this! The directions are easy to follow!

2016-11-10 09:32:00


I still cannot seem to see line 1-3

2016-10-17 01:51:16


additionally, check if worksheet has panes frozen specially the upper first few rows, then maybe you can see the first few rows.

2016-03-02 10:36:21


I couldn't get my top rows to unhide with any of the standard methods, but found that, if you just click the 'page layout view' button on the bottom right toolbar, it unhides and unfreezes everything. Then you just click the normal view button. Easy!

2015-04-24 09:10:53


Thank you Ferdie! I had frozen panes too.

2015-03-15 16:19:23


YES!!! I actually called Microsoft support and they couldn't tell me how to unhide the top rows. I wish I would have found this page first! It would have saved me a lot of time and frustration.

2015-02-24 07:50:29


OK Solution found!! I had FROZEN PANES set - took it off and unhiding worked!!

2015-02-24 07:33:49


I have the same experience as Koyaanisqatsi - no pointer shape changes anywhere taking place to the doublebar and 2 arrows as shown in the jpg picture. My sheet has rows 1-3 hidden somehow... None of the other options works for me aqs well. Using Excel 2010... Any other ideas?

2015-02-04 09:49:43


It all depends on your preference, Michael. I prefer not to touch my mouse if I don't have to.
I do appreciate the tip and all of the options that everyone suggested. That is why I watch this site, to learn new ways.

2015-02-04 06:11:26

Michael (Micky) Avidan

Too much energy vesting.
Placing the cursor on the upper border of cell A2 and double-clicking sounds (to me) much, much, easier.
Michael (Micky) Avidan
“Microsoft® Answers" - Wiki author & Forums Moderator
“Microsoft®” MVP – Excel (2009-2015)

2015-02-03 11:31:19


With rows 1,5-8 hidden:
F5 A 1 <Enter> Ctrl+Shift+9 will unhide row 1 without affecting 5-8.


2015-02-03 06:02:14

Michael (Micky) Avidan

How, exactly, does your (well known) short-cut suggestion help me if I have:
Row #1 Hidden + Rows 5-8 Hidden and all I want is to Un-Hide row #1 ?
Michael (Micky) Avidan
“Microsoft® Answers" - Wiki author & Forums Moderator
“Microsoft®” MVP – Excel (2009-2015)

2015-02-02 10:29:12

Angie C.

Another way to unhide a top row is to do this: If rows 1 & 2 are hidden, select row 3 with the left mouse button and drag upwards. Then right click anywhere in row 3 and choose "unhide".
NOTE: You must right click in row 3 (and not in the column header 'A, B C' row).

2015-02-02 10:12:45


Thanks for the tips on various ways to 'go to' the hidden rows. I find using Ctrl+Shift+9 is a quick keyboard shortcut for unhiding defined rows.

2015-02-02 05:14:43


I stand corrected. The mouse pointer should be positioned, like Richard pointed out, over the boundary line between this arrow and the first unhidden row. Thanks too to those who pointed to the double click- possibility. Didn't think of that.

2015-02-02 02:41:07

Richard Price

The instruction "move the mousepointer to the top left corner of the sheet, the one that looks like an arrow pointing downwards to the right" is slightly misleading - if you hover right over that arrow nothing happens, as you said. What you actually need to hover over is the boundary line between this arrow and the first unhidden row.

2015-02-01 06:10:31

Michael (Micky) Avidan

Take a good look at the picture and you'll see the "new" shape of the curser while hovering over the border above(!) row #2.
This is when you need to Double-Click.
Michael (Micky) Avidan
“Microsoft® Answers" - Wiki author & Forums Moderator
“Microsoft®” MVP – Excel (2009-2015)

2015-01-31 19:35:50



2015-01-31 09:59:36


Bengt, no need to drag, just double click.

I am interested in the 2:3 or 1:1 possibilities, could help me, going to test.

Note: If rows 1-4 are hidden and the pointer is put on row five, moving up till the double lines with one up arrow and one down arrow appear a double click will return rows 1-4. However if rows 6,7,8 are hidden you can bring them back one at a time by going to row 5 or 9 and moving till the double line/double arrow appears and double clicking, second double click bring back another row, etc.
To bring back all row at once select both rows 5 and 9, get double line/double arrow and double click.

I would have preferred the one line return to have move one line from 5 to return 6, but it appears it always returns the highest line first.

2015-01-31 06:32:36


To select all the hidden rows at the top of a worksheet:
Put your mouse over the first visible row number and click and drag up to the select all button. With the hidden rows selected you can now follow steps 4,5,6 of the original tip.

2015-01-31 06:30:29


There's no such pointer shape change when hoovering and/or mousedown on the mentionned corner in my version of Excel (2013). Did you configure your Excel in a special way, or is it older than 2013?

2015-01-31 06:09:47

Michael (Micky) Avidan

When the shape looks like two parallel bars - try double clicking the left mouse button (No dragging needed).
Michael (Micky) Avidan
“Microsoft® Answers" - Wiki author & Forums Moderator
“Microsoft®” MVP – Excel (2009-2015)

2015-01-31 04:54:45


IMHO, there is a much simpler solution for the problem of unhiding hidden rows.
If you move the mousepointer to the top left corner of the sheet, the one that looks like an arrow pointing downwards to the right, you will notice that the pointer changes shape and looks like two parallel bars and two arrows, one pointing upwards, one downwards. If you then press your left mouse button and drag downwards, the hidden rows will be unhidden.


This Site

Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.

Newest Tips

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.