Excel Row 1 Missing – How to Get it Back
A colleague brought her Microsoft Excel sheet to me asking for help. Row 1 was missing. It was invisible.
She's pretty smart...she tried selecting all rows (click the little box in the upper left corner above the Row numbers and to the left of the Column letters), and choosing Format, Row, Unhide. But that didn't work.
We selected cell A2, and used the "up" arrow, and the cell locator box (to the left of the formula bar) indicated that the cursor was, indeed, in A1. That means the row was not hidden.
In cell A1, we typed some text, then set the format to be 20pt. Then we selected all, then Format, Row, AutoFit. Still nothing.
I suspected it might be something to do with Panes. I went to Window, and noticed the "Unfreeze Panes" option was available. We clicked it, and the missing Row 1 was instantly visible again! Problem solved!
If your Excel Row 1 is not visible, give those few steps a try!
Linda - http://how.best-free-information.com - The "How" Blog
![[del.icio.us]](http://images.del.icio.us/static/img/delicious.small.gif){kind=small}