USING MICROSOFT EXCEL
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
To keep selected rows and / or columns of the worksheet visible on the screen as the rest of the worksheet scrolls.
|
|
Split Panes
|
|
|
Freeze Panes
|
|
|
Divide Panes
|
|
|
None of the above
|
Explanation:
Detailed explanation-1: -To lock top row in Excel, go to the View tab, Window group, and click Freeze Panes > Freeze Top Row. This will lock the very first row in your worksheet so that it remains visible when you navigate through the rest of your worksheet.
Detailed explanation-2: -If you want the row and column headers always visible when you scroll through your worksheet, you can lock the top row and/or first column. Tap View > Freeze Panes, and then tap the option you need.
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.