Excel Annoyances

PRINT LAYOUT ANNOYANCES

PUT PAGE BREAKS WHERE YOU WANT ‘EM

The Annoyance:

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 RUNNER

When 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 ...