Excel 365 in 30 Minutes – Printing (Basics 10 of 10)

In this Bigger Brains course, you’ll see how to take control of Excel’s printing tools so your worksheets look great on paper every time. You’ll learn how to use Print Preview to adjust print settings, modify margins with Show Margins, and work with the Page Setup dialog box to finetune layout options. You’ll explore how to set or clear a print area, repeat rows or columns with Print Titles, print gridlines, and adjust scale settings so your data fits perfectly on the page. You’ll also learn how to identify, insert, and adjust page breaks—both from the Ribbon and using Page Break Preview—giving you full control over what prints on each page. 

You’ll also see how to add professional headers and footers from Page Layout View, customize them using the Header & Footer contextual tab, and even set different header and footer options for the first printed page. You’ll explore default header/footer options, as well as how to create custom elements through the Page Setup dialog box. Whether you print reports, financial summaries, forms, or multipage worksheets, you’ll learn essential tools and techniques to ensure your Excel printouts look polished and consistent. 

Topics covered include: 

• Accessing Print Preview View to modify Print Settings 

• Manually modifying margins using Show Margins 

• Modifying Print Settings from the Page Setup Dialog Box 

• Setting or clearing a Print Area 

• Setting Print Titles to repeat columns or rows when printing 

• Printing gridlines 

• Inserting a new Page Break from the Ribbon 

• Viewing and modifying Page Breaks and changing the Print Area using the Page Break Preview View 

• Manually setting the number of printed pages in the Scale to Fit Group 

• Adding Headers and Footers from Page Layout View 

• Using the Header & Footer contextual tab to add custom elements 

• Setting your worksheet to have a different header and footer on the first printed page 

• Adding Headers and Footers from the Page Setup Dialog Box 

Enjoy award winning HD content in the “Uniquely Engaging”™ Bigger Brains Teacher-Learner style! Taught by top subject matter experts, Bigger Brains courses are professionally designed around key learning objectives and include captions and transcripts, downloadable handouts, and optional LinkedIn digital badges on course completion.