So in the above screenshot, we can see that ‘Sheet3’ is now visible to us that was previously hidden. This will display the selected hidden sheet. Now select the sheet that is to be unhidden and then click on ‘OK’. On using this Excel shortcut key, the Unhide dialogue box (same as we saw in the above two examples) will appear with all the hidden worksheets. Example #3Īpart from the above two ways that we have used to unhide one sheet at a time, there is another method to open the same ‘Unhide’ dialog box and then unhide the required hidden sheet. Now we can repeat the above steps to unhide ‘Sheet3’ as well. So in the above screenshot, we can see that ‘Sheet2’ is now visible to us that was previously hidden.
Now select the sheet that is to be unhidden and then click on ‘OK.’ This will display the selected hidden sheet. The following screenshot illustrates this. On doing this, an Unhide dialog box will appear with all the hidden worksheets. Right-click on any of the worksheet tabs and then select ‘Unhide.’ Now, we wish to unhide ‘Sheet2’ and ‘Sheet3’ in the same Excel workbook. So in the above screenshot, we can see that ‘Sheet1’ is now visible to us that was previously hidden. We can repeat the above steps if we wish to unhide the other two sheets.
0 kommentar(er)
