USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
At times, you may want to compare certain rows or columns without changing the organization of your worksheet. To do this you can ____ columns and rows.
|
Cut
|
|
Organize
|
|
View side by side
|
|
Hide
|
Explanation:
Detailed explanation-1: -Right-click the selected columns, and then select Hide.
Detailed explanation-2: -On the Home tab, in the Cells group, click Format. Do one of the following: Under Visibility, click Hide & Unhide, and then click Unhide Rows or Unhide Columns.
Detailed explanation-3: -Select the cell below the rows and to the right of the columns you want to keep visible when you scroll. Select View > Freeze Panes > Freeze Panes.
Detailed explanation-4: -Hiding Rows Select a cell within the row(s) to be hidden. On the Home command tab, in the Cells group, click Format. From the Format menu, in the Visibility section, select Hide & Unhide ยป Hide Rows.
There is 1 question to complete.