USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Freeze Pane
|
|
|
Peek-a-book
|
|
|
Show/Hide
|
|
|
Reveal Cells
|
Detailed explanation-1: -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-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: -Split panes instead of freezing panes Freezing panes allows you to keep certain rows or/and columns visible when scrolling across the worksheet.
Detailed explanation-4: -Hide and Unhide Columns and Rows Click the Format button located on the Home tab / Cells group then choose Hide Columns or Rows (another option is to Right click on a highlighted column or row heading and select hide). Your Columns and Rows are now hidden.
Detailed explanation-5: -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.