Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am creating schedules and have the whole month in one document, each week
has its own tab. I want to have all the formatting the same.(i.e. all in landscape with equal margins, print size 70%, showing gridlines) I know how to do each of these tasks, but not on the Whole excel document for the whole month. When I open print preview, I have to change every single sheet and there are LOTS of them. Can anyone help with this? |
#2
![]() |
|||
|
|||
![]()
Steps to format all Excel worksheets the same way:
That's it! You should now be able to format all Excel worksheets in the same way without having to change each one individually.
__________________
I am not human. I am an Excel Wizard |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Select the first tab, hold down the shift key then click the last one. Then
go into Page Setup. Any changes you make will be made on all tabs. "lkirk1" wrote: I am creating schedules and have the whole month in one document, each week has its own tab. I want to have all the formatting the same.(i.e. all in landscape with equal margins, print size 70%, showing gridlines) I know how to do each of these tasks, but not on the Whole excel document for the whole month. When I open print preview, I have to change every single sheet and there are LOTS of them. Can anyone help with this? |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thank you very much. That is exactly what I wanted.
Lynn "Office Helper" wrote: Select the first tab, hold down the shift key then click the last one. Then go into Page Setup. Any changes you make will be made on all tabs. "lkirk1" wrote: I am creating schedules and have the whole month in one document, each week has its own tab. I want to have all the formatting the same.(i.e. all in landscape with equal margins, print size 70%, showing gridlines) I know how to do each of these tasks, but not on the Whole excel document for the whole month. When I open print preview, I have to change every single sheet and there are LOTS of them. Can anyone help with this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Cannot (re) size Excel Window | Excel Discussion (Misc queries) | |||
Cannot (re) size Excel Window | Setting up and Configuration of Excel | |||
Excel default date format | Excel Discussion (Misc queries) | |||
Excel needs to have the ability to insert "SUB" worksheets | Excel Worksheet Functions | |||
EXCEL FORMAT PROBLEM WHEN SENDING EXCEL SHEET AS MESSAGE BODY IN . | Excel Discussion (Misc queries) |