Formula to hide blank rows

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Not without resorting to VBA code. Autofilter is a solution that will
require just two mouse clicks to hide all the unnecessary rows.
 
Okay - thanks.

Ken Wright said:
Not without resorting to VBA code. Autofilter is a solution that will
require just two mouse clicks to hide all the unnecessary rows.
Click to expand...
 
Back
Top