Avoid to print cells containing ""

[born_wild]

Hello.
I have a worksheet containing of 20000 rows collecting info from other worksheets, mainly by codes like =IF($Sheet1.A1>"";$Sheet1.A1;"").
The result is dynamic; sometimes are all the 20000 rows populated, other times nearly 10000.
My problem is when I want to print this worksheet; my Excel wants to print all 20000 cells regardless of there is some values in the rows or the cells in the row is "". Is there any way that I can prevent the "empty" rows containing only "" of being printed?

[mehmetcik]

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[born_wild]

I've uploaded a demo now.
In my main-file there's several Source Sheets, but in the demo only one.
If I, in my demo, try to print the Source Sheet it says that it is 3 pages, but if I want to print the To_Print Sheet it's 6 pages due to the fact that som cells at the bottom returns "", and Excel obvious thinks that it is a printable value
The cells at the bottom that returns "" is to show that there may be more cells containing info than what I've added.

[avk]

Select filter non blank & select actual data.
>Go to file > print > select "Selection" > ok