Formula to hide blank rows

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.
 
G

Guest

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.
 
K

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.
 
G

Guest

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hiding rows and printing 1
Hide columns based on row values 2
Creating a function to auto hide rows 1
Basing math on duplicate entries in a formula 1
Hiding Rows 3
Hide Rows If Condition True 2
Inserting blanks or changing dimensions 1
hiding blank rows 3

Top