Microsoft Excel 2021365 - Beginner to Advanced - Inserting Page Breaks

The video tutorial covers how to adjust print settings in Excel to ensure all columns fit on one page. It explains the use of Page Break Preview to identify where pages will break and how to manually adjust these breaks for better readability. The tutorial also demonstrates inserting and resetting manual page breaks to customize the print layout.

What was the initial problem with the spreadsheet's print layout?

• The margins were too wide.

• The orientation was set to portrait.

• The font size was too small.

• Not all columns fit on one page.

What tool in Excel helps visualize where pages will break?

• Gridlines View

• Page Break Preview

• Print Preview

• Page Layout View

How can you manually adjust a page break in Excel?

• By adjusting the margins

• By dragging the blue dashed line

• By changing the font size

• By changing the orientation

What is the visual difference between manual and automatic page breaks in Excel?

• There is no visual difference.

• Manual breaks are solid lines.

• Automatic breaks are solid lines.

• Manual breaks are dotted lines.

What happens when you reset all page breaks in Excel?

• The orientation changes to portrait.

• The font size is increased.

• The document is printed immediately.

• All manual breaks are removed.