How to select all worksheets in a workbook

[Faith]

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!

 

[John C]

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

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

 

[Sheeloo]

Press CTRL and click on the sheets you want...if you want to select all
then Right-Click on anyone and choose 'Select All Sheets...'

 

[muddan madhu]

right click on sheet name | select all sheets |

 

[JE McGimpsey]

One way:

Select the left-most tab. Shift-click the right-most tab. Edit.

Just be sure to ungroup (Ctrl-click a tab and choose Ungroup) before
making edits you want to be in only one sheet.

 

[Margy]

Right Click on any Worksheet tab and on the shortcut menu click on Select
All. All Worksheets will be selected and you can format all of them at the
same time.

 

[Faith]

I was just about to delete my post because I saw the answer in another post
(using the CTRL key to select the worksheets). I did not, however, know about
the right-click, Select All Sheets option.

Thanks so much for your help and your quick reply!

 

[Bernard Liengme]

If you right click a worksheet tab there is an option "Select all Sheets"
Then use File | Page Setup
best wishes

 

[Sheeloo]

You are welcome.
Pl. mark the post as answered to help other users with similar requirment.