Dynamic Print Range with cells containing formulas !

L

LP

Greetings all Excel Experts !

I have 200 rows that contain formulas. If I only fill 100 of them
with data and print the page I get a lot of empty pages. How can I
make Excel print ONLY the 50 rows with data. Likewise, if my file
grows to 150 rows, Excel needs to adjust the print range accordingly
to accommodate up to 150 rows.

I know you can select the area before printing and then print selected
area.
But I want excel to print only the rows where say column D <>"". Keep
in mind that all columns in this sheet contain formulas. Is this
possible?

Many thanks !!

LP
 
B

Bernie Deitrick

Set the print range to be all used rows, but use a data filter based on column D to hide/show rows
where column D = ""

HTH,
Bernie
MS Excel MVP
 

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

How do I make a dynamic print range in excel? 5
Dynamic Print Area 7
Printing a worksheet with and without formulas showing 1
Extending formulas with gaps in reference 2
Excel 2007 not calculating margins & print area correctly 7
Deleting blank rows with formulas in them 7
VBA to set dynamic print area 1
When printing - ability to not print empty or $0 cells 1

Top