missing rows

  • Thread starter Thread starter Robert de Brus
  • Start date Start date
R

Robert de Brus

I'm sure there is a simple solution to this, but so far it has eluded me.

A client's spreadsheed has recently gone a bit weird. The row numbers on the
affected worksheets have turned blue, and many rows are missing.

I figured out the missing rows have been resized to nothing, but it's a time
consuming job to set them back to normal size, as there are dozens or more.

Surely there is a more efficient way to resize them all in one hit? I tried
selecting them all and resizing with Format/Row/Auto and Format/Row/Height
(12.75) but to no avail.

I was informed that they had the BugbearB a few days ago, but that appears
to be gone now. From all the reading I've done on BugbearB it doesn't cause
this sort of behaviour.

Any help would be much appreciated
 
Als je echt wil helpen begin dan met het veranderen van het adres dat je
gebruikt in je post:

Domain name: BAD.COM

Registrant:
Scott Enterprises, Ltd.
P.O. Box 309 , Ugland House
George Town, Grand Cayman
KY
 
Robert said:
I'm sure there is a simple solution to this, but so far it has eluded me.

A client's spreadsheed has recently gone a bit weird. The row numbers on the
affected worksheets have turned blue, and many rows are missing.

A filter is active. Data menu
 
Robert said:
Yep, got it. Thanks

It's possible they set up the filter by accident, or just forgot about
it, but you ought to check for dodgy macros.
 
Back
Top