"For myself I am an optimist--it does not seem to be much use being anything else."
-- Sir Winston Churchil
Change print page to A4
We receive worksheets from other divisions that have the paper size set to Letter. This affects how the pages print out on A4 paper. Is there an easy way to convert all the sheets in a workbook to the A4 paper size?
By Neale Blackwood, 1 Dec 06
The macro
below will adjust the paper size to A4 for every sheet
in the active workbook.
Sub A4Paper()
Dim sht As Worksheet For Each sht In Sheets
sht.PageSetup.PaperSize = xlPaperA4
Next sht
End Sub
First published: CPA AUSTRALIA Magazine
INTHEBLACK December 2006 - Page 14 Excel Yourself
Change page orientation on all sheets - Is there a quick way to change the page orientation from portrait to landscape on all the sheets in a workbook?
Yes. Right
click on the sheet name tabs, click Select All Sheets.
Now click the File menu, select Page Setup, then click
the Page tab (if it isn't already displayed) change the
Orientation to Landscape, click OK ...
To print
all the sheets, right click any of the sheet tabs and
choose Select All Sheets ...
Print Title Tips - How do I set up titles when printing in Excel? I can see the area I need to change but it is 'greyed out' in the Sheet tab of the Setup section of Print Preview?
This is a common problem in Excel.
To put titles ie; Rows to repeat at the top of the page
and Columns to repeat on the left of the page when you
print out sheets, you need to go into the File menu and
click Page Setup and then click the Sheet tab ...
Print
