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:
Click the downward-pointing arrow to the right of the Quick Access toolbar.
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. ...