Chapter 11: Printing
Author: Joseph Rubin, CPA www.exceltip.com
9. Right-click, and from the shortcut menu, select Order, Send to
10. Adjust the object’s size and location to suit the sheet.
Excel allows you to include objects (dropdown menus, buttons, text
boxes, arrows and more) in a sheet for a variety of purposes. It also
allows you to decide if you want them to be hidden when you print or not.
There are a number of ways to prevent objects from being printed. Select
File, Page Setup, Sheet. Select the Draft quality checkbox, and click OK.
Right-click the object, and select Format Object type. Select the
Properties tab, and select the Print object checkbox if you want to print it.
Tip – Make printing faster
Objects make printing go slower, so you may want to
temporarily delete them before printing by pressing Ctrl+6+6.
After printing, press Ctrl+6 to reinsert the objects into the
Selecting print options
With Excel, you can print whatever print areas you choose by using the
Selection option. Select the area you want to print. From the File menu,
select Print. From the Print What section, select Selection. This allows
you to print the area you want without changing the Print_Area of the
sheet (remember, the Print-Area is the last print area that was defined).
Select the Entire workbook option to print the Print_Areas of all the
sheets in the workbook.
To print a number of reports regularly, use the Report Manager (see