Prevent blank pages (with formulas) from printing

NV Social Worker

New Member
Joined
Nov 9, 2020
Messages
2
Office Version
  1. 2016
Platform
  1. Windows
I have a workbook with formulas that result in blank cells, unless data is placed in other cells (A16:Y300). I only want the pages with data in them to print, but it is trying to print all of the blank pages that have formulas in them (I have rows 1:15 to print for each page). I am not familiar with macros or VBA, and am only moderately familiar with formulas. I know I can put in a filter to not print the blank pages, but I have people who will be using the workbook that can barely even input the data, and would not know how to use the filter. I would like for them to just click print and only the pages with data to print (currently, it is printing 10 pages). I looked through the message board and found this, which I have tried to no avail:

To not print formulas in blank cells:
Go to Formulas Tab
Click on Define Name
In Name box, type name of worksheet and Print_Area
In Scope box, click on the workbook
In the formula box (Refers to:) type in …
=OFFSET(Service Log!$A$1:$Y$1,0,0,LOOKUP(2,1/(Service Log!$A$2:$A$300<>""),ROW(Service Log!$A$2:$A$300)))

If anyone can assist me with this issue, I would be most grateful.

Thank you,

NVSW
Service Log (1).PNG
Service Log (2).PNG
 

Some videos you may like

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

NV Social Worker

New Member
Joined
Nov 9, 2020
Messages
2
Office Version
  1. 2016
Platform
  1. Windows
I just realized, my cells do not contain formulas, but they do contain conditional formatting. I cannot find a way around this not printing 10 pages. Again, any assistance would be tremendously appreciated!
 

Watch MrExcel Video

Forum statistics

Threads
1,127,402
Messages
5,624,532
Members
416,032
Latest member
dunhamsasphalt

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
Top