USING MICROSOFT EXCEL
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which Tab can you locate the Freeze Panes button?
|
|
Home
|
|
|
Insert
|
|
|
View
|
|
|
Data
|
Explanation:
Detailed explanation-1: -Select the row below the row(s) you want to freeze (select row 6, if you want to freeze rows 1 to 5). On the View tab, click Freeze Panes > Freeze Panes.
Detailed explanation-2: -To keep an area of a worksheet visible while you scroll to another area of the worksheet, go to the View tab, where you can Freeze Panes to lock specific rows and columns in place, or you can Split panes to create separate windows of the same worksheet.
Detailed explanation-3: -You’re scrolling down your worksheet (or scrolling to the side), but part of it is frozen in place. This is probably because at some point you decided to freeze the panes. To fix this, click View > Window > Unfreeze Panes.
There is 1 question to complete.