Microsoft Office Tutorials and References
In Depth Information
Tip 12: Where to Change Printer Settings
Where to Change Printer Settings
If you want to print a copy of a worksheet with no fuss and bother, use the Quick Print option. One
way to access this command is to choose File➜Print (which displays the Print pane of Backstage
view) and then click the Print button.
However, if the default print settings aren’t good enough, you must make some adjustments. A little
tweaking of the print settings can often improve your printed reports.
Unfortunately, Excel has no one-stop location for adjusting print setting. You can adjust print
settings in three places:
➤ The Print settings screen in Backstage view, which opens when you choose File➜Print.
➤ The Page Layout tab of the Ribbon.
➤ The Page Setup dialog box, which opens when you click the dialog launcher in the
lowerright corner of the Page Layout➜Page Setup group on the Ribbon. You can also access the
Page Setup dialog box from the Print settings screen in Backstage view.
Table 12-1 summarizes the locations where you can make various types of print-related adjustments
in Excel 2013.
Table 12-1: Where to Change Printer Settings
Setting
Print Settings
Screen
Page Layout
Tab of Ribbon
Page Setup
Dialog Box
Number of copies
X
Printer to use
X
What to print
X
Specify worksheet print area
X
X
1-sided or 2-sided
X
Collated
X
Orientation
X
X
X
Paper size
X
X
X
Adjust margins
X
X
X
Specify manual page breaks
X
Specify repeating rows and/or columns
X
Set print scaling
X
X
Print or hide gridlines
X
X
Print or hide row and column headings
X
X
continued
 
Search JabSto ::




Custom Search