format all excel worksheets the same orientation, size
 

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?

Answer: format all excel worksheets the same orientation, size
 

Steps to format all Excel worksheets the same way:

1. Open the Excel workbook that contains all the worksheets you want to format.
2. Click on the first worksheet tab at the bottom of the screen.
3. Hold down the Shift key on your keyboard and click on the last worksheet tab. This will select all the worksheets in the workbook.
4. Right-click on any of the selected worksheet tabs and choose "Select All Sheets" from the context menu.
5. With all the worksheets selected, go to the Page Layout tab in the ribbon.
6. In the Page Setup group, click on the small arrow in the bottom right corner to open the Page Setup dialog box.
7. In the Page Setup dialog box, you can set the orientation to Landscape, adjust the margins, set the print size to 70%, and check the box to show gridlines. Make sure to click on the "OK" button to apply the changes.
8. Now, when you go to Print Preview, all the worksheets should have the same formatting.

That's it! You should now be able to format all Excel worksheets in the same way without having to change each one individually.

format all excel worksheets the same orientation, size
 

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?

format all excel worksheets the same orientation, size
 

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?