View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Landscape entire workbook

Carol

Right-click on a sheet tab and "select all sheets"

Set the active sheet for Landscape and all sheets will be done.

DO NOT FORGET to right-click and "ungroup" after.


Gord Dibben MS Excel MVP

On Fri, 6 Oct 2006 07:40:02 -0700, Carol
wrote:

Is there a way to set an entire workbook to print in landscape without having
to select/set each sheet individually? This would be after the workbook has
been created.