How can I format a multi-sheet workbook from A4 to letter without.

[Guest]

I receive multi-sheet workbooks from our office overseas. They use A4 paper
to print and I need to manually change each sheet to print it. Is there a
quicker way? Like the old Global function in Lotus? Perhaps a macro?

 

[Guest]

if you are changing entire sheets or the same amount/size of cells in every
sheet, you can select those particualer cells, then hold down "ctrl" and
click they sheets you want to format. if you are selecting, say, A1:F19 then
you use my trick it will format those cells in all the selected sheets.