How do you: (a) Hide a column, (b) Unhide a column, (c)Hide a worksheet, (d) Unhide a worksheet?
Answers
Answer:
Once the hidden column cell is selected, follow the below steps:
Click the Home tab.
In the Cells group, click on Format.
Hover the cursor on the 'Hide & Unhide' option.
Click on 'Unhide Columns'
Answer:
Explanation:
Hide:-
Column Row's
Step - 1 Select the column or rows you want to hide by clicking on the column header or row.
Step - 2 Right click on the column to hide and click on the hide option.
UNHIDE SEELCTED COLUMNS AND ROWS.
Step - 1 Select the visible range of columns and rows that includes the hidden columns or rows.
Step - 2 Now right click on the selected columns select unhide from the pop - up menu.
Hide or Unhide the worksheet :-
Right click on the select tab which you want to hide or unhide.
Step - 2 Choose hide option from the content menu.
Step - 3 To unhide the middlesheet, right click on any of the visible sheet unhide dialogue will appear. Choose the sheet from the list to unhide.