Do not print blank cells that contain a formula

[avidcat]

I have a couple excel sheets that contain formula's, a good 20 pages working down from row #1. These rows populate based on selections on the sheet.

The problem I am having is that when you go to print I will get about 15 pages of blank paper coming after the data is printed.

Is it possible to print only viewable information?

Thanks,
Nick

[martindwilson]

set the print area accordingly would seem to be the obvious answer or are you after something else?

[avidcat]

I can't set the print area as the data might change. It might be 5 pages or 10 pages of data to print based on what is selected on the page.

Basically I could enter a date range and those dates would populate on the sheet.

I am thinking it might not be possible, but wanted to see if anyone had a way of doing this.

thanks,
Nick

[martindwilson]

well it doesnt take that long to set the print area, but you can just print whats highlited instead just select what you want printed then file /print/print selection /ok

[avidcat]

For me it is not a problem, it was for the 20 other co-workers who also use this excel file.

Wanted to see if there was a way to do it with a setting I was not aware of.

Thanks for your input.

Nick