FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
To hide columns or rows temporarily, right-click the column/row heading and click ____
A
HIDE
B
CLIPBOARD
C
Either A or B
D
None of the above
Explanation: 

Detailed explanation-1: -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-2: -Click anywhere in the table. Go to the Table tab on the Ribbon. In the Table Style Options group, select the Header Row check box to hide or display the table headers.

Detailed explanation-3: -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-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.
Previous
Next