Re: how to Hide rows? if cells are blank?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Ken Wright (ken.wright_at_NOSPAMntlworld.com)
Date: 04/12/04

  • Next message: RagDyer: "Re: Formula to text?" 
    Date: Mon, 12 Apr 2004 23:17:28 +0100

    OK, as per the other post:-

    Either we are all talking by each other here, or something is screwy somewhere.
    This is something that would usually be a 2 second job to most of the regulars,
    so I know we're not all losing it. Are you able to send me the file at all so I
    can take a look first hand, only we've pretty much covered most things it could
    be??

    ken.wright [at] ntlworld.com 

    -- 
Regards
           Ken.......................    Microsoft MVP - Excel
              Sys Spec - Win XP Pro /  XL 97/00/02/03
----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------
"Steven" <me@where.why> wrote in message news:cwEec.175$Nt1.104@newsfe1-win...
> nope and its not grouped.
>
> Steve
>
> "Ken Wright" <ken.wright@NOSPAMntlworld.com> wrote in message
> news:O6hU4rNIEHA.3444@TK2MSFTNGP11.phx.gbl...
> > Is the *** protected or something??
> >
> > -- 
> > Regards
> >            Ken.......................    Microsoft MVP - Excel
> >               Sys Spec - Win XP Pro /  XL 97/00/02/03
> >
> > --------------------------------------------------------------------------
> --
> > It's easier to beg forgiveness than ask permission :-)
> > --------------------------------------------------------------------------
> --
> >
> >
> >
> > "Steven" <me@where.why> wrote in message
> news:bqEec.172$Nt1.97@newsfe1-win...
> > > Autofilter is still not available, its greyed out, for now I im using
> sort
> > > and manually hiding the rows :(
> > >
> > > cheers for the help,
> > >
> > > Steve
> > >
> > > "Anne Troy" <dreamboat@piersontech.com> wrote in message
> > > news:LPWdneUAALAikebdRVn-sw@comcast.com...
> > > > You're the man, Ken.
> > > >
> > > > "Ken Wright" <ken.wright@NOSPAMntlworld.com> wrote in message
> > > > news:%23mWtLmLIEHA.308@tk2msftngp13.phx.gbl...
> > > > > Select that column and do Data / Filter / Autofilter, then click on
> the
> > > > dropdown
> > > > > arrow and choose Show
> > > > >
> > > > > -- 
> > > > > Regards
> > > > >            Ken.......................    Microsoft MVP - Excel
> > > > >               Sys Spec - Win XP Pro /  XL 97/00/02/03
> > > > >
> > > >
> > >
> > --------------------------------------------------------------------------
> > > > --
> > > > > It's easier to beg forgiveness than ask permission :-)
> > > >
> > >
> > --------------------------------------------------------------------------
> > > > --
> > > > >
> > > > >
> > > > > <snip>
> > > > >
> > > > >
> > > > > ---
> > > > > Outgoing mail is certified Virus Free.
> > > > > Checked by AVG anti-virus system (http://www.grisoft.com).
> > > > > Version: 6.0.656 / Virus Database: 421 - Release Date: 09/04/2004
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
> > ---
> > Outgoing mail is certified Virus Free.
> > Checked by AVG anti-virus system (http://www.grisoft.com).
> > Version: 6.0.656 / Virus Database: 421 - Release Date: 09/04/2004
> >
> >
>
>
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.656 / Virus Database: 421 - Release Date: 09/04/2004
  • Next message: RagDyer: "Re: Formula to text?"
    • Quantcast