All articles with 'page setup' Tag

Hui’s Excel Report Printer

Published on Sep 14, 2011 in Excel Howtos, Huis, Posts by Hui, VBA Macros
Hui’s Excel Report Printer

Do you enjoy printing complex spreadsheets with multiple pages with different print ranges and different setups on each page for different people who have different requirements ?

If the answer is No…

This post may save your day and change your life.

Continue »

How to Print Excel Comments

Published on Dec 16, 2009 in Excel Howtos, Learn Excel
How to Print Excel Comments

We all know how to make comments on excel documents, just select the cell where you want a comment, press SHIFT+F2 and make the comment. But the comments are only visible when you open the workbook. What if you want to print out an excel file, but include all the comments as well?

Turns out you can do that with a hidden option in excel page setup.

Continue »

Hide Formula Errors While Printing [Quick tip]

Published on May 27, 2009 in Excel Howtos, Learn Excel
Hide Formula Errors While Printing [Quick tip]

Here is a quick excel printing tip. Use the page setup options from print preview area of the spreadsheet to select how you want to handle the formula errors when the worksheet is printed. You can set it to blank from the “sheet” tab of the page setup dialog in Microsoft excel

Continue »