Link to home
Start Free TrialLog in
Avatar of Stephen Kairys
Stephen KairysFlag for United States of America

asked on

Excel 2016 - Row 1 missing

Excel 2016/Win10:

Row 1 on my spreadsheet (titles) does not display. I tried typing A1 in the Name box, but that tactic did not help. I do not remember hiding this row; in fact, I don't even know how to perform that function.

Cans someone please suggest steps to "recover" this row?

Thanks!
Steve
Avatar of Wilder1626
Wilder1626
Flag of Canada image

Hi,One way would be to select the top left corner of the excel grid. This gray out all cells from your excel file:
User generated image
Then position your mouse cursor on one of the rows headers (on any numbers), right click on it and select Unhide.
User generated image
This will unhide any hidden rows.

Another way after again selecting the top left corner of the excel grid would be to select Row Height option instead of Unhide.
If you put 15, this is the default height and it will show you back the row 1 again.

But just make sure to again select the top left corner of the excel grid.

User generated image
User generated image
User generated image put a check mark in headings
ASKER CERTIFIED SOLUTION
Avatar of Wilder1626
Wilder1626
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Stephen Kairys

ASKER

@David - "Headings" was already checked.
@Wilder1626 - Your solution worked.

Thanks, everyone!
i'm glad i was able to help!