By David Ringstrom, CPA
- Right-click on the QAT and then choose Customize Quick Access Toolbar.
- When the Excel Options dialog box appears, choose Commands Not in the Ribbon.
- Scroll down the list until you find Print Preview Full Screen. Alternatively, you can click once on one of the first commands on the list, and then press P to jump down the list close to where Print Preview Full Screen resides.
- Double-click on Print Preview Full Screen to add it to your Quick Access Toolbar. You can also click once on it and choose Add, but double-clicking saves a step. Note that it's important to choose Print Preview Full Screen as opposed to Print Preview and Print. The latter simply provides easier access to the Backstage View on the File menu.
- Optionally, move Print Preview Full Screen further up the list. Each icon on the QAT is given a numeric keyboard shortcut. As shown in Figure 1, Print Preview Full Screen is the fourth icon on the list. This means on my computer I can press Alt-4 to display the classic Print Preview screen.
- Click OK once you're satisfied with the positioning of the new icon on your QAT.
- Click the arrow at the end of the QAT.
- Choose Print Preview.
- Right-click on the QAT and choose Customize Quick Access Toolbar.
- Choose All Commands (instead of Commands Not in the Ribbon as you did in Excel).
- Double-click Print Preview Edit Mode (instead of Print Preview Full Screen). You may see a Print Preview Full Screen command, but in Word that command doesn't work in the same fashion as Excel.
David H. Ringstrom, CPA heads up Accounting Advisors, Inc., an Atlanta-based software and database consulting firm providing training and consulting services nationwide. Contact David at firstname.lastname@example.org or follow him on Twitter. David speaks at conferences about Microsoft Excel, and presents webcasts for several CPE providers, including AccountingWEB partner CPE Link.