blue row numbers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have blue row numbers and hidden rows that won't unhide but I see no
evidence of grouping. There isn't any numbers at the top or anything. I can
manually resize the row height but even if I save it afterwards when I go
back into it the rows are hid again. Does anyone know why? And how to fix it?
 
Do any of your columns have a dropdown arrow on them? there might be a
filter applied. Go into Data>Filter, and if the Autofilter has a tick mark,
click it and see if this reveals all the rows.

--

HTH

RP
(remove nothere from the email address if mailing direct)


Grannet said:
I have blue row numbers and hidden rows that won't unhide but I see no
evidence of grouping. There isn't any numbers at the top or anything. I can
manually resize the row height but even if I save it afterwards when I go
back into it the rows are hid again. Does anyone know why? And how to fix
Click to expand...
it?
 
Hi Grannet,
Is a filter responsible for this.
On the main menu bar click on Data then Filter. Is there a tick next to
any of the indicated filters? If so click to remove the filter.
Ken Johnson
 
And if no drop-down arrows and Data>Autofilter is grayed out check
Tools>Options>View>Objects

Put a Checkmark at "Show all"

Now do you have dropdown arrows?


Gord Dibben Excel MVP
 
Back
Top