Formula to hide blank rows

[Ladyra]

I have a nine page order form - my question is if it is possible to hide a
row if the item in that row is not chosen. I want to end up with a two or
three page order form showing customer choices instead of nine pages of half
filled in rows - any suggestions? Thanks.

[Ken Wright]

Take a look at Data / Filter / Autofilter on whatever field denotes being
chosen

http://www.contextures.com/xlautofilter01.html

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Ladyra" <[email protected]> wrote in message
news:[email protected]...
> I have a nine page order form - my question is if it is possible to hide a
> row if the item in that row is not chosen. I want to end up with a two or
> three page order form showing customer choices instead of nine pages of
half
> filled in rows - any suggestions? Thanks.

[Ladyra]

I looked at filters but I was really just wanting a formula that would hide
or delete a complete row if there was no selection by "X" in that row - is
this possible? Thanks for your help.

"Ken Wright" wrote:

> Take a look at Data / Filter / Autofilter on whatever field denotes being
> chosen
>
> http://www.contextures.com/xlautofilter01.html
>
> --
> Regards
> Ken....................... Microsoft MVP - Excel
> Sys Spec - Win XP Pro / XL 97/00/02/03
>
> ----------------------------------------------------------------------------
> It's easier to beg forgiveness than ask permission :-)
> ----------------------------------------------------------------------------
>
> "Ladyra" <[email protected]> wrote in message
> news:[email protected]...
> > I have a nine page order form - my question is if it is possible to hide a
> > row if the item in that row is not chosen. I want to end up with a two or
> > three page order form showing customer choices instead of nine pages of
> half
> > filled in rows - any suggestions? Thanks.
>
>
>

[Ken Wright]

Not without resorting to VBA code. Autofilter is a solution that will
require just two mouse clicks to hide all the unnecessary rows.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Ladyra" <[email protected]> wrote in message
news:[email protected]...
> I looked at filters but I was really just wanting a formula that would
hide
> or delete a complete row if there was no selection by "X" in that row - is
> this possible? Thanks for your help.
>
> "Ken Wright" wrote:
>
> > Take a look at Data / Filter / Autofilter on whatever field denotes
being
> > chosen
> >
> > http://www.contextures.com/xlautofilter01.html
> >
> > --
> > Regards
> > Ken....................... Microsoft MVP - Excel
> > Sys Spec - Win XP Pro / XL 97/00/02/03
> >
>
> --------------------------------------------------------------------------
--
> > It's easier to beg forgiveness than ask permission :-)
>
> --------------------------------------------------------------------------
--
> >
> > "Ladyra" <[email protected]> wrote in message
> > news:[email protected]...
> > > I have a nine page order form - my question is if it is possible to
hide a
> > > row if the item in that row is not chosen. I want to end up with a
two or
> > > three page order form showing customer choices instead of nine pages
of
> > half
> > > filled in rows - any suggestions? Thanks.
> >
> >
> >

[Ladyra]

Okay - thanks.

"Ken Wright" wrote:

> Not without resorting to VBA code. Autofilter is a solution that will
> require just two mouse clicks to hide all the unnecessary rows.
>
> --
> Regards
> Ken....................... Microsoft MVP - Excel
> Sys Spec - Win XP Pro / XL 97/00/02/03
>
> ----------------------------------------------------------------------------
> It's easier to beg forgiveness than ask permission :-)
> ----------------------------------------------------------------------------
>
> "Ladyra" <[email protected]> wrote in message
> news:[email protected]...
> > I looked at filters but I was really just wanting a formula that would
> hide
> > or delete a complete row if there was no selection by "X" in that row - is
> > this possible? Thanks for your help.
> >
> > "Ken Wright" wrote:
> >
> > > Take a look at Data / Filter / Autofilter on whatever field denotes
> being
> > > chosen
> > >
> > > http://www.contextures.com/xlautofilter01.html
> > >
> > > --
> > > Regards
> > > Ken....................... Microsoft MVP - Excel
> > > Sys Spec - Win XP Pro / XL 97/00/02/03
> > >
> >
> > --------------------------------------------------------------------------
> --
> > > It's easier to beg forgiveness than ask permission :-)
> >
> > --------------------------------------------------------------------------
> --
> > >
> > > "Ladyra" <[email protected]> wrote in message
> > > news:[email protected]...
> > > > I have a nine page order form - my question is if it is possible to
> hide a
> > > > row if the item in that row is not chosen. I want to end up with a
> two or
> > > > three page order form showing customer choices instead of nine pages
> of
> > > half
> > > > filled in rows - any suggestions? Thanks.
> > >
> > >
> > >
>
>
>