John Walkenbach's Favorite Excel 2010 Tips and Tricks

Chapter 10. Printing

We haven't quite reached the paperless office yet, so it's still important to get your work on paper in a way that looks good. The tips in this part deal with printing and previewing your work.

Tips and Where to Find Them

• Tip 183 Controlling What Gets Printed 397

• Tip 184 Displaying Repeated Rows or Columns on a Printout 399

• Tip 185 Printing Noncontiguous Ranges on a Single Page 400

• Tip 186 Preventing Objects from Printing 403

• Tip 187 Page-Numbering Tips 404

• Tip 188 Adding and Removing Page Breaks 406

• Tip 189 Saving to a PDF File 407

• Tip 190 Making Your Printout Fit on One Page 408

• Tip 191 Printing the Contents of a Cell in a Header or Footer 410

• Tip 192 Copying Page Setup Settings Across Sheets 412

• Tip 193 Printing Cell Comments 413

• Tip 194 Printing a Giant Banner 414

Controlling What Gets Printed

This tip deals with some printing basics.

Displaying the Quick Print button

No, your eyes don't deceive you. It's true that Excel 2010, by default, doesn't display a Print button on the Ribbon. The "normal" way of printing a document is to choose the File

If you like the idea of one-click printing, make a change to your Quick Access toolbar:

1. Click the downward-pointing arrow to the right of the Quick Access toolbar.

2. Choose Quick Print.

After you complete these steps, the Quick Access toolbar displays a new icon. Click the icon, and Excel prints the entire contents of the active worksheet. ...