Microsoft Excel 2021365 - Beginner to Advanced - Freezing Panes

The video tutorial explains how to use the Freeze Panes utility in Excel to keep specific rows or columns visible while scrolling through a worksheet. It covers the options to freeze the top row, the first column, and custom selections. Additionally, it introduces the Split option, which allows users to view different parts of a worksheet simultaneously. The tutorial provides practical examples and tips for effectively managing large datasets in Excel.

What problem does the 'Freeze Top Row' option solve?

• It allows you to edit multiple rows simultaneously.

• It keeps the top row visible while scrolling through the worksheet.

• It highlights the top row in a different color.

• It automatically sorts the data in the top row.

Which option would you use to keep the first column visible while scrolling horizontally?

• Split

• Freeze First Column

• Unfreeze Panes

• Freeze Top Row

How can you customize which rows and columns are frozen in a worksheet?

• By using the 'Freeze Top Row' option

• By selecting 'Freeze First Column'

• By using the 'Freeze Panes' option based on current selection

• By applying the 'Split' option

What is the purpose of the 'Split' option in a workbook?

• To automatically adjust column widths

• To highlight specific rows and columns

• To merge multiple cells into one

• To divide the workbook into separate scrollable sections

How do you remove a split that has been applied to a workbook?

• By clicking the 'Unfreeze Panes' button

• By selecting 'Remove Split' from the menu

• By dragging the split line off the screen

• By clicking the 'Split' button again