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

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

Post by Q2F0Y2gxMD » Thu, 11 Nov 2004 03:25:03


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?
 
 
 

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

Post by UHJpbmdsZX » Thu, 11 Nov 2004 03:35:04

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.