Thursday, May 7, 2015

Excel Tips & Tricks: Print Preview



If you send or receive Excel files by email, you’ll love this tip!

Have you ever received an Excel file by email, opened it up and sent it to the printer—only to hear the printer take off and start running off a ream of paper? The creator of the worksheet probably neglected to check the Print Preview to see how the worksheet would look when printed, and didn’t set any Print Formats.

Whenever you email a worksheet, consider that it might get printed, and set the Print Format to print properly on paper (maybe add some headers or footers to provide context when it is printed). Basic settings like Portrait vs Landscape orientation, margin size, sheet size and scaling can be found using the Print Preview function (Ctrl-P). Click on the page setup link for more options.

No comments: