Unhiding a Worksheet in a Workbook

Which two options from the following unhide a worksheet in a workbook?

Option 1: Right-click a worksheet tab, and click Unhide.

Option 2: Right-click anywhere in the worksheet, and click Unhide.

Option 3: On the Home tab, click Format in the Cells group, select Hide & Unhide, and click Unhide Sheet.

Option 4: On the Page Layout tab, select View in the Sheet Options.

Answer: Right click a worksheet tab and click unhide.

Explanation:

In order to hide a page worksheet tab, right click the worksheet which you want to hide, there will be an option to hide and unhide. To unhide, you can right click any of the sheet, then click on unhide. It will show a list of sheets which are hidden in the workbook. Select the desired name so that it will appear. Hiding is different from protecting a sheet. Hiding will take the sheet from the screen but will not delete. Protect will avoid editing of the sheet until a valid password is given.

Which shortcut keys can you use to unhide a worksheet in a workbook?

Answer: bottom, shift, ctrl

Explanation: edge 2020

← Creating a clustered column pivotchart in excel How to round fractions in electrical calculations →