blue row numbers in excel

G

Guest

I have blue row numbers and hidden rows. I have read that it is due to
grouping but I don't see any signs of grouping. There are no numbers or
anything at the top. I can manually resize the hidden rows but not by the
format menu. I can't unhide the rows by right click or the menu. Can anyone
help me?
Also, when I manually resize the rows and save it then close it and go back
to it the rows are hid again.
 
S

stend3

Your data is filtered. Select Data | Filter | Show All from the menu
and the rows will come back.
 
G

Guest

Thank you so much. I kept reading about the grouping and knew that wasn't the
problem so I did what you said and turned off all the filters and sure enough
everything is back. Thanks again.
 

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

blue row numbers 3
Row numbers are blue 1
Cannot unhide the hidden rows in my spreadsheet 3
Unhide a row 1
What does a blue row number means? 2
new unwanted toolbar i can't switch off 2
Missing row numbers 3
hide/unhide macro 2

Top