Well, first click the first of the sheet tabs (those tabs with the sheet
names at the foot of the spreadsheet)
Then Shift-click the last of those tabs
You will now see 'Group' in the workbook title bar, the blue bar at the top
of the workbook/spreadsheet
The sheets are now grouped, so anything that you do on the one that you see,
including formatting, will be replicated on the others.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"camalex03" wrote in message
...
I guess I am not as experienced as I thought. I don't follow you. Could
you
explain a different way maybe? I am sorry.

"Bob Phillips" wrote:

Select them all with the sheet tabs (select the first, then click-select
the
last, and you will see Group in the workbook title bar), and then apply
your
format.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"camalex03" wrote in message
...
I have a workbook with 20+ worksheets. I don't want to waste a lot of
time
formating each page for margins and landscape. Is there a way to set
just
this one workbook to format the same from the first page?