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.