How To Unhide A Worksheet In Excel

Then i will show you a few tricks of how to unhide all sheets. This is an exceptionally useful feature as it allows us to store data in a sheet such as lists and tables but keep the user of the workbook from seeing manipulating and more importantly corrupting the information on the hidden sheet.

Unhide Multiple Worksheets In Excel

However they can easily unhide the worksheet if they want as we will see later in this tutorial.

How to unhide a worksheet in excel. As shown in figure 1 on the home tab choose format hide and unhide and then hide sheet. Hiding and unhiding worksheets in excel is a straightforward task. You can hide unhide worksheets using excel vba.

Select the workbook and click the ok button to display it. If there are multiple hidden workbooks you will find them all listing in the unhide dialog box after clicking the unhide button in step 1. When you exit excel you will be asked if you want to save changes to the hidden workbook window.

To unhide multiple sheets you will have to repeat the above steps for each worksheet individually or you can unhide all sheets in one go by using the below macros. I will start by showing a way to manually unhide an excel worksheet using the excel unhide window. Or to save a couple of steps right click on the worksheet tab and then choose hide.

Each cell can hold text a number or a formula and each cell can reference a different cell on the same worksheet the same workbook or a different workbook. Excels unhide option only allows you to select one sheet at a time. If there is only one hidden workbook after clicking the unhide command the hidden workbook will show up.

Excel 2007 and later. One of the first tricks an excel user learns is to hide and unhide a sheet. An excel worksheet is a single spreadsheet that contains cells.

In excel click the view tab then click unhide in the window group. If unhide is unavailable the workbook does not contain hidden workbook windows. For example you may be developing a tracker for different departments in an organization.

There are a couple of different ways to hide worksheets in excel. When you unhide a worksheet you can only do so one at a time so select from the list of hidden sheets in the unhide dialog box. You can hide a worksheet and the user would not see it when heshe opens the workbook.

With the handy toggle button of worksheets provided by kutools for excel you can one click to show all hidden worksheets in the active workbook and click it again to toggle all hidden worksheets to be invisible. Vba hide unhide worksheets example macro macro helps when we have many worksheets in a workbook and you want to show only specific worksheets to the user. Full feature free trial 60 day.

To unhide sheets in excel you need to right click on the worksheet tab and select the worksheet you want to unhide from the unhide window. Toggle hidden worksheet visibility one click to unhide all hidden sheets and one click to restore hidden. But what if you dont want them to be able.

For instance carry out these steps to hide a single worksheet.