Thread: Print Area
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jeff
 
Posts: n/a
Default Print Area

Hi,

I have a worksheet with about 15 tabs, all with similiar tables except that
they have different numbers. I format the print area, by highlighting
selected portions of the worksheet and choosing "add to print area", but the
problem is that I have to do this manually to each of the 15 tabs. Is there
a way to do this automatically?
Someone said to highlight all the tabs and go into page setup, but this does
not work since I have to use the Page Break and "add to print area" to select
the parts I want to print.

Thanks