When I print my multipage worksheet, the content breaks in places where I'd rather it didn't. I'd like to keep certain parts of the worksheet together in the printout, but thanks to the size of the worksheet, the paper I'm printing on, and the formatting of the content, I can't seem to get things to print in the right places.
AUTOMATE REPORT PRINTING WITH REPORT RUNNERWhen you work for a large or medium-size company, you often have to print the same workbooks over and over. It's no bother to print out one report every week, but if you have 10 or 12 workbooks you have to print out that often, you need a tool that can automate the process. Enter the Report Runner from OzGrid, which lets you tell Excel to follow a series of steps when it's time to print a batch of workbooks. You don't even need to open the workbooks! Once you tell the program which workbooks you want to print it simply takes over. The main Report Runner dialog box appears in the following figure. Each step has its own built-in instructions, but there are some restrictions and recommendations (print ranges should be named, and so on). I recommend reading the help file so that you know how the Report Runner saves your preferences and sequences, and what your output options are. You can purchase the Report Runner for $29.95 from http://www.ozgrid.com/Services/excel-report-runner.htm. After you download the add-in, you install it by choosing Tools → Add-Ins, clicking the Browse button, navigating to the directory that contains the add-in, and double-clicking it. This handy tool helps you create custom printing macros without knowing a lick of code. |