by Allen Wyatt
(last updated May 10, 2014)
Kathy used to use Report Manager in Excel 2003 for a monthly report that spanned several worksheets. She wonders if there is a way to create a multi-worksheet report and be "print ready" with the latest versions of Excel. She has been working with views, but once she selects more than one worksheet, the Custom View button is gray.
There is no need to use custom views to get the output you want. In fact, you don't need to use anything except regular print areas and the printing capabilities of Excel. Follow these general steps if you are using Excel 2007:
Figure 1. The Print dialog box.
That's it; you end up with a printout that spans the multiple worksheets and includes only the appropriate print area on each worksheet. If you are using Excel 2010 the steps are a bit different:
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (9391) applies to Microsoft Excel 2007, 2010, and 2013.
Comprehensive VBA Guide Visual Basic for Applications (VBA) is the language used for writing macros in all Office programs. This complete guide shows both professionals and novices how to master VBA in order to customize the entire Office suite for their needs. Check out Mastering VBA for Office 2010 today!
Tired of wasting paper when you print a worksheet? You can scale Excel's output so that it fits only the number of pages you ...Discover More
If you want to cram more of your worksheet onto each page of a printout, one way to do it is by using scaling. Here's how you ...Discover More
When you print a worksheet, you may want to specify that the printout be done on a particular paper tray in a particular ...Discover More
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.