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!

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!

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...'
--
Always provide your feedback so that others know whether the solution worked
or problem still persists ...


"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!

right click on sheet name | select all sheets |



On Oct 20, 11:44*pm, 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!

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.

In article ,
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!

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.
--
Always provide your feedback so that others know whether the solution worked
or problem still persists ...

--
Margy


"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!

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!

"Sheeloo" wrote:

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...'
--
Always provide your feedback so that others know whether the solution worked
or problem still persists ...


"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!

If you right click a worksheet tab there is an option "Select all Sheets"
Then use File | Page Setup
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Faith" wrote in message
...
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!

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

--
Always provide your feedback so that others know whether the solution worked
or problem still persists ...


"Faith" wrote:

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!

"Sheeloo" wrote:

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...'
--
Always provide your feedback so that others know whether the solution worked
or problem still persists ...


"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!