Hidden Rows

K

KD

Hi there,

Thank you in advance for any help. I have a worksheet
with the top 9 rows hidden. I can't seem to get them to
unhide.

I've checked the help file and tried the suggestion there
Edit > Go To > A1 then Format > Row > Unhide but it
doesn't seem to work.

I still can't see those top 9 rows. Any other
suggestions I can try?

Thanks,

KD
 
K

KD

No check by Autofilter, but I tried checking it then
unchecking it just in case but didn't do anything.
 
K

KD

Ok strange thing but might help someone else.

After looking to see if anything else was checked that
shouldn't be, I noticed that there were frozen panes. I
unfroze the panes(which were not any of the 9 just fyi)
and then went through the steps to unhide again edit>go
to> a1 then format>row>unhide and it worked those rows
showed up.

Not sure why it happened but thanks for the help!

KD
 
N

Norman Harker

Hi KD!

Thanks for reporting back with your solution. That always helps others
who Google Search on the problem.
 

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

Repeating a row other than the 1st row as the header row in a table from next page 1
Drop down list control value in vba 2
Slideshow with black border around it 0
Unwanted line across top of pages; how to delete? 0
Sort partially hidden data 1
Accidentally clicked 'Don't Save' on a new Powerpoint presentation! Please help! 0
Help needed for inserting a row. 0
form buttons on sheet collapse on unhide - sometimes 5

Top