Don't Print Row if value in cell in this row is Null, Blank, or Zero

FRED_SHEET

New Member
Joined
Oct 13, 2017
Messages
48
I have a cell in a Microsoft Excel Worksheet row with a calculated formula.

If this cell is Null, Blank, or Zero I would not like the row this cell is in to be printed.

Is there any way to do this? :confused:
 

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK
Use the autofilter, uncheck those 3, print the sheet and then remove the filter.
 
Upvote 0
I created a table and used the autofilter and it worked OK. I am new to tables and my original worksheet seems to have disappeared. I am going to have to do some research to determine how an existing worksheet and a table work together. It would be ideal if the user could input the original data into a table and it would auto fill the original worksheet. The table definitely looks like it gives you some options. I had another post where they suggested a table although I can't seem to find that post.

Thanks for the answer it did what I wanted.
 
Upvote 0
A bit puzzled by what you are stating as the "original" worksheet. A table is part of the worksheet.

Btw, you can autofilter on a normal worksheet without a table.
 
Last edited:
Upvote 0
Thank you I did check the autofilter on the normal worksheet, it worked OK.

I am going to try and create the table again and see if I can understand what is happening if it is part of the worksheet.
 
Upvote 0

Forum statistics

Threads
1,224,825
Messages
6,181,191
Members
453,021
Latest member
pingpong7117

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top