Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dynamic Print Range with cells containing formulas !
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dynamic Print Range with cells containing formulas !
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 "LP" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I make a dynamic print range in excel? | Excel Discussion (Misc queries) | |||
Dynamic Range in Excel that won't count formulas | Excel Discussion (Misc queries) | |||
Hlp! Protect Cells in Dynamic Range | Excel Discussion (Misc queries) | |||
Macro print range not dynamic like I wanted it to be | Excel Worksheet Functions | |||
Dynamic Print Range Help | Excel Worksheet Functions |