FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Which of the following statements describes how to unhide a hidden row or column?
A
Select a range of cells in the row or column, right-click, and select Unhide.
B
Use the Page Setup dialog box.
C
Remove all page breaks.
D
Select the rows/columns before and after the hidden rows/columns and then right-click and select Unhide.
Explanation: 

Detailed explanation-1: -Which of the following statements describes how to unhide a hidden row or column? Select the rows/columns before and after the hidden rows/columns and then right-click and select Unhide.

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: -The shortcut for unhiding columns in Excel is Ctrl + Shift + 0. To make the hidden columns visible, highlight at least one cell in the columns on both sides of the hidden one(s), and use the shortcut.

There is 1 question to complete.