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.

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" wrote in message
...
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.

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" wrote in message
...
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.

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" wrote in message
...
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" wrote in message
...
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.

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" wrote in message
...
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" wrote in message
...
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.