Excel: Page Layout and Printing

TL;DR

Learn how to print worksheets in Excel, including selecting specific sheets, creating print selections, adjusting page orientation and scaling, repeating header rows, and controlling page breaks.

Transcript

Workbooks can be used completely electronically, but sometimes you need to print them too. It's important to understand the basics of printing, plus the other things you have control over—like what parts of the worksheet to print, and more. You'll find everything you need in the backstage view… in the Print pane. Here you can adjust your settings, ... Read More

Key Insights

• 😫 Excel's backstage view provides a comprehensive set of tools for adjusting print settings and previewing worksheets.
• 👤 Users can choose to print specific sheets, the entire workbook, or custom selections of data in Excel.
• 👣 Page orientation, scaling, and print titles can be adjusted to improve the readability and clarity of printed worksheets.
• 📟 Page break preview mode allows for manual adjustment of page breaks to evenly divide data on printed pages.

Questions & Answers

Q: How can you print only specific sheets in an Excel workbook?

To print specific sheets, hold the Ctrl key and select the desired sheets while in the Print pane of the backstage view. Excel will print only the selected sheets.

Q: Can you print a custom selection of data instead of an entire worksheet?

Yes, you can select the specific data you want to print (including the header row) and then navigate to the Print pane. Switch from "Print Active Sheets" to "Print Selection" to see a print preview of only the selected data.

Q: How can you create a permanent print selection in Excel?

You can create a permanent print selection using the "Set Print Area" command found on the Page Layout tab. Simply select the desired data, go to the menu, and choose "Set Print Area." To remove the print area, choose "Clear."

Q: How can you repeat header rows for clarity while printing in Excel?

Go to the Page Layout tab and click on the "Print Titles" command. Select the range of rows or columns you want to repeat (such as the header row), and Excel will include it on every printed page for easy reference.

Summary & Key Takeaways

• Excel's backstage view allows users to adjust print settings, see a preview, and print their workbook all in one place.

• Users can choose to print either the active sheets, the entire workbook, or a specific selection of data.

• Page orientation, scaling, and page breaks can be adjusted to fit more rows or columns on each page, and header rows can be repeated for clarity.