Can all the sheets in one workbook all the same?
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?
|