very odd problem - rows have disappeared. Not hidden, height is no

  • Thread starter Thread starter PBcorn
  • Start date Start date
P

PBcorn

the first two rows of a workbook are not visible, so it appears to begin with
row 3. rows 1 and 2 can be referenced, but not actually viewed, eg. formula
=a1 returns the value in a1, but a1 and the entire row is not visible. I have
tried unhiding, does not work. Increasing the height of the invisible row
also fails to make it visible.
 
Perhaps someone did Windows-->Freeze Panes with the worksheet slightly
scrolled down. Check and see if you can go to Windows-->Unfreeze Panes.
 
Maybe you have panes frozen.

In xl2003 menus:
Window|Unfreeze panes
and then scroll up.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Row Hidden or height set to 0 7
Row Height property 1
hidden rows problem 7
Hidden rows 2
Row 1 Hidden 5
hidden top row?? 9
Autofit row height when retrieving text via formula 3
Conditional Formatting and Autofilter 4

Back
Top