Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 138
  • Last Modified:

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
0
Stephen Kairys
Asked:
Stephen Kairys
  • 3
1 Solution
 
Wilder1626Commented:
Hi,One way would be to select the top left corner of the excel grid. This gray out all cells from your excel file:
Top_left
Then position your mouse cursor on one of the rows headers (on any numbers), right click on it and select Unhide.
Unhide
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.

Row height option
row height value
0
 
David Johnson, CD, MVPOwnerCommented:
Headings Show/HIde put a check mark in headings
0
 
Wilder1626Commented:
Another way would be to do as below snapshot
A1_cell
0
 
Stephen KairysTechnical Writer - ConsultantAuthor Commented:
@David - "Headings" was already checked.
@Wilder1626 - Your solution worked.

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

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now