Delete a Row if the Cell is empty

I

Ian Holm

Hi i am new to excel but i am required to make a sheet and i ned to know how
to remove a row from the page if a certain cell value is 0 or blank. I need
this to happen just before i print the worksheet.

would i use a macro for this or something else?

Thanks

Ian
 
J

JMay

Look at Auto-Filtering; It will allow you to condense data down to only what
you want to see (and Print).
 

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

If cell empty delete row 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Macro to delete row if 8
delete row if 2 cells are empty 1
if+delete row 2
Delete row with empty cell in column 3
Excel formula, sum the value cell and if empty cell left blank 0
Delete ROW based on Cell Contents 4

Top