View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.programming
[email protected] dguillett@gmail.com is offline
external usenet poster
 
Posts: 27
Default Efficient printing

On Saturday, November 8, 2014 1:44:19 PM UTC-6, Robert Crandal wrote:
My workbook is about 5 pages long. Each page contains column
headers at the top. If a users fills up the rows of the first two
pages, and presses print, Excel will print all 5 pages. But, really
only the first two pages needed to be printed.

What are some good methods to force Excel to only print pages
that contain "data"?


How about just hiding the rows you don't want to printprintunhide