Long-term Excel users will recall that Excel has historically provided a separate Print Preview window that made it easy to zoom in and adjust settings. Excel 2010 introduced a new "Backstage View" where print preview became embedded into the File menu. Excel 2013 continues this new tradition, but you can get your "old-school" print preview functionality back with a few quick steps.
To accomplish this, we're going to add an icon to Excel's Quick Access Toolbar (QAT). As shown in Figure 1, the QAT typically resides at the top of your Excel screen and serves as a custom toolbar of your making. To begin:
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.
To access all of the content on our site, register (it's free!) or login to your existing account.
BONUS: If you register now you can opt to receive a digital copy of "Transform!" , Richard Francis' new book for growing firms [US/Canada ONLY].
David H. Ringstrom, CPA, is an author and nationally recognized instructor who teaches scores of webinars each year. His Excel courses are based on over 25 years of consulting and teaching experience. His mantra is “Either you work Excel, or it works you.” David offers spreadsheet and database consulting services nationwide.