Small Excel tip

Not really a discussion point but a small tip for Excel 2007 and 2010 users. (At least this was useful for me but you probably all know about it already!)

 

Excel 2007 and 2010 have the extremely useful "Save as pdf" option. However, when saving multiple sheets in this format, the page size can vary giving an irritatingly inconsistent pdf file.

 

To overcome this:

Excel 2007: Office Button - Excel Options - Advanced - General section and untick "Scale content for A4 or 8.5 x 11" paper sizes"

Excel 2010: File - Options - Advanced - General section and untick "Scale content for A4 or 8.5 x 11" paper sizes"

 

Add comment
Log in or register to post comments
Group: ExcelZone
A gathering place for the Excel community to explore new ideas and techniques and a forum to debate product features and best practices.