Excel won't allow access to some rows!--- Very strange!!

  • Thread starter Thread starter Investwise
  • Start date Start date
I

Investwise

I have a strange problem with one of my spreadshteets. I am not able
to access or see any rows 1 to 31. It is as if the "hide" function is
in effect. I have tried the "unhide" function, but no use. It is as
if I am locked out of these rows! I don't have any "freeze" function
active with respect to the unaccesible rows.

Anyone here knows what is going on? thanks
 
When you try and unhide select the whole sheet by clicking the border above
and to the left of cell A1 and then try unhide rows and then also try row
heightr standard.
 
Martins solution works, but it "unhides" all the rows (or columns). If you
only want to unhide (say) row 6, press F5 ("go to"), enter A6, then Unhide.
This will just unhide the one row.

Rob
 
You must log in or register to reply here.

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

Expand and collapse rows 7
rows won't unhide 5
Insert a row without taking formats from above (upper) rows or cells 6
Unable to unhide some hidden rows 4
insert rows with formulas 1
Excel Freezes 4
How to unhide rows....when they won't unhide 7
Visible row index after applying a filter in Excel 1

Back
Top