missing rows

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


---
Message has been scanned and is, to the best of my knowledge, Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.495 / Virus Database: 294 - Release Date: 1/07/2003

Ben je Nederlands? Help ik je in het Nederlands...

"Robert de Brus" <de_brus@h o t m a i l.com> schreef in bericht
news:AdwMa.8288$eE.101300@nasal.pacific.net.au...
> 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
>
>
> ---
> Message has been scanned and is, to the best of my knowledge, Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.495 / Virus Database: 294 - Release Date: 1/07/2003
>
>

Zal wel belg zijn

"Me AgAiN?" <thats@bad.com> schreef in bericht
news:3f02ac06$0$28908$edd6591c@news.versatel.net...
> Ben je Nederlands? Help ik je in het Nederlands...

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



Me AgAiN? wrote:
>
> Ben je Nederlands? Help ik je in het Nederlands...
>
> "Robert de Brus" <de_brus@h o t m a i l.com> schreef in bericht
> news:AdwMa.8288$eE.101300@nasal.pacific.net.au...
> > 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
> >
> >
> > ---
> > Message has been scanned and is, to the best of my knowledge, Virus Free.
> > Checked by AVG anti-virus system (http://www.grisoft.com).
> > Version: 6.0.495 / Virus Database: 294 - Release Date: 1/07/2003
> >
> >

Robert de Brus wrote:
>
> 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 de Brus wrote:
>
> Andrew.Sliversalts wrote:
> > Robert de Brus wrote:
> >>
> >> 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
>
> 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.
--
Dearie dear!