Excel Printing and Page Layout

Join Excel expert David Ringstrom, CPA, for a comprehensive session on "Excel Printing and Page Layout," designed to transform how you handle hard copies and PDF generation. Printing in Excel often feels like a source of constant frustration, where small inefficiencies add up to significant lost time. This course aims to help you reclaim your day by mastering the art of printing efficiently, navigating Excel's quirks, and utilizing hidden shortcuts to produce professional documentation with ease.

Throughout this presentation, you will dive deep into the nuances of setting print areas, adjusting page breaks, and effectively previewing output. You will learn how to referee the tricky conflict between the Freeze Panes and Page Layout features, ensuring your data remains viewable on screen and on paper. The course also covers essential customization techniques, such as controlling the visibility of floating objects like slicers, adjusting headers and footers, and printing charts on dedicated pages.

Beyond the basics, this course introduces powerful tools to speed up your workflow. You will discover how to use Custom Views to toggle between different print settings and hidden rows without creating multiple versions of the same worksheet. Finally, David walks you through a step-by-step process to create a Universal Print Macro. Even if you have zero experience with coding, you will learn to implement a custom dialog box that allows you to pick and choose specific worksheets to print with a single click.

Key learning outcomes and topics covered in this course include:

• Mastering print ranges, including expanding, splitting, and selecting non-contiguous areas to print on separate pages.
• Managing manual page breaks and navigating the Page Break Preview screen to fit data perfectly.
• Repeating header rows and columns on every page and adding gridlines or row and column headings to printouts.
• Creating Quick Access Toolbar shortcuts for immediate printing, PDF publishing, and emailing attachments.
• Using Custom Views to save and recall complex print settings and hidden row configurations instantly.
• Implementing a "Plug-in Print" macro to automate printing specific sheets via a user-friendly form.

Whether you are using Microsoft 365 for Windows or looking to understand the nuances of Excel for Mac, this course provides the tools you need to achieve print automation and eliminate common formatting frustrations.