DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
total panes
|
|
excel panes
|
|
freeze panes
|
|
None of the above
|
Detailed explanation-1: -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-2: -On the View tab, select the Freeze Panes command, then choose Freeze Panes from the drop-down menu. The rows will be frozen in place, as indicated by the gray line. You can scroll down the worksheet while continuing to view the frozen rows at the top.
Detailed explanation-3: -Go to the View tab of a worksheet to select Freeze Panes, which locks specific rows and columns in place when you scroll to another area, or Split Panes, which creates separate windows of the same spreadsheet.
Detailed explanation-4: -Split a sheet into panes When you split a sheet into separate panes, you can scroll in both panes independently. Select below the row where you want the split, or the column to the right of where you want the split. On the View tab, in the Window group, click Split. To remove the split panes, click Split again.
Detailed explanation-5: -Freeze top row Keeps only the top row visible as you scroll through a worksheet. Freeze First Column Keeps only the first column visible as you scroll through a worksheet. To freeze one or more rows and columns, use the Freeze Panes option.