USING MICROSOFT EXCEL
HOW TO INSERT HEADERS FOOTERS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Excel allows you to ____ columns and rows, so that Excel displays their content on the screen, no matter how far down or to the right you scroll.
|
|
hold
|
|
|
stop
|
|
|
freeze
|
|
|
shrink
|
Explanation:
Detailed explanation-1: -On the View tab, in the Window group, click the arrow below Freeze Panes. time, click Freeze Panes. Unfreeze Panes so that you can unlock any frozen rows or columns. freeze rows and columns in the middle of the worksheet.
Detailed explanation-2: -The Excel Freeze Panes option allows you to lock your columns and/or rows so that when you scroll down or over to view the rest of your sheet, the column and/or row will remain on the screen.
Detailed explanation-3: -To freeze horizontal and vertical headings simultaneously: Select the cell in the upper-left corner of the range you want to remain scrollable. Select View tab, Windows Group, click Freeze Panes from the menu bar.
There is 1 question to complete.