Maximize Excel: Printing and Page Layout
Presented by David H. Ringstrom, CPA
 
Event Date/Time: 8/17/26 3:00 PM Eastern
Duration: 100 minutes
 
It’s easy to prepare documents for printing once you learn how to implement a variety of Excel features and techniques. Step-by-step, Excel expert David Ringstrom, CPA, demonstrates how to enable a full-screen print preview, use Excel’s Custom Views feature to apply different print settings, pick and choose worksheets you want to print, and more. David’s tips will help you work faster and more efficiently when laying out and printing your Excel documents.
 
David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in the subscription-based Microsoft 365 (formerly Office 365) version of Excel. David draws your attention to any differences in the older versions of Excel (2021, 2019, 2016 and earlier) during the presentation as well as in his detailed handouts. David also provides an Excel workbook that includes most of the examples he uses during the webcast.
 
Microsoft 365 is a subscription-based product that provides new feature updates as often as monthly. Conversely, the perpetual licensed versions of Excel have feature sets that don't change. Perpetual licensed versions have year numbers, such as Excel 2021, Excel 2019, and so on.
 
Who should attend:
Practitioners seeking to use Microsoft Excel more effectively
 
Topics typically covered:
 
• Exploring the nuances of page breaks within Excel worksheets.
 
• Learning how to deal with annoying changes to Print Preview in Word 2010 and later.
 
• Leveraging the header and footer tools to have better control over controlling what prints at the top and or bottom of each page of a document.
 
• Navigate Excel menus entirely by keyboard shortcuts.
 
• Printing a list of all cell comments on a worksheet or printing visible comments.
 
• Printing any aspect of a worksheet selectively.
 
• Printing only a chart from a worksheet.
 
• Restoring “classic” Print Preview functionality in Excel 2010 and later.
 
• Saving paper and eliminating frustration by monitoring the Print Scale setting.
 
• Seeing how to print a spreadsheet on the fly via Windows Explorer instead of manually opening a workbook in Excel.
 
• Setting a print range that includes multiple noncontiguous areas of a worksheet.
 
• Streamlining repetitive printing tasks by adding Quick Print to the Quick Access Toolbar.
 
Learning objectives:
Demonstrate the easiest way to print a single chart that resides on a worksheet.
Recall the location of the Print Titles command within Excel’s menu.
Identify the command you can add to the Quick Access Toolbar to streamline access to Print Preview on Excel’s File menu.
 
Level:
Intermediate
 
 
Instructional Method:
Group: Internet-based
 
NASBA Field of Study:
Computer Software & Applications (2 hours)
 
Program Prerequisites:
Prior Experience with Microsoft Excel
 
Advance Preparation:
None