View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
John C[_2_] John C[_2_] is offline
external usenet poster
 
Posts: 1,358
Default How to select all worksheets in a workbook

Right click on one of your tabs, Select All Sheets.

Any changes made on one sheet, will carry to all sheets.
--
John C


"Faith" wrote:

Is there a way to select all worksheets in a workbook so that I can perform
some of the same formatting options (orientation, margins, etc.) on all of
them at once?

Thanks!