Can You Hide Template Buttons In Intermediate

Hibernate or unhide a worksheet

Annotation:The screen shots in this article were taken in Excel 2016. If yous have a different version your view might be slightly different, only unless otherwise noted, the functionality is the same.

Select the worksheets that y'all want to hide.

How to select worksheets

To select	Do this
A unmarried canvass	Click the canvas tab. If you don't see the tab that you lot want, click the scrolling buttons to the left of the sheet tabs to display the tab, and then click the tab.
Two or more than next sheets	Click the tab for the first sheet. Then hold downward Shift while yous click the tab for the final canvass that you desire to select.
Two or more nonadjacent sheets	Click the tab for the showtime sheet. And then hold down Ctrl while you click the tabs of the other sheets that you want to select.
All sheets in a workbook	Right-click a sheet tab, and so click Select All Sheets on the shortcut menu.

Tip:When multiple worksheets are selected, [Group] appears in the title bar at the top of the worksheet. To cancel a selection of multiple worksheets in a workbook, click whatever unselected worksheet. If no unselected sail is visible, right-click the tab of a selected sheet, and so click Ungroup Sheets on the shortcut menu.

On the Home tab, in the Cells group, click Format > Visibility > Hibernate & Unhide > Hide Sail.
To unhide worksheets, follow the aforementioned steps, simply select Unhide. You'll be presented with a dialog box listing which sheets are hidden, so select the ones you desire to unhide.

Notation:Worksheets hidden by VBA code have the belongings xlSheetVeryHidden; the Unhide control volition non display those subconscious sheets. If y'all are using a workbook that contains VBA lawmaking and you come across bug with hidden worksheets, contact the workbook possessor for more information.

Hide or unhide a workbook window

On the View tab, in the Window group, click Hide or Unhide.

On a Mac, this is under the Window menu in the file card to a higher place the ribbon.

Notes:

When you lot Unhide a workbook, select from the listing in the Unhide dialog box.
If Unhide is unavailable, the workbook does not contain hidden workbook windows.
When you exit Excel, yous will be asked if yous want to save changes to the hidden workbook window. Click Yeah if you want the workbook window to be the aforementioned every bit you left it (hidden or unhidden), the next time that yous open the workbook.

Hibernate or display workbook windows on the Windows taskbar

Excel 2013 introduced the Single Document Interface, where each workbook opens in its own window.

Click File > Options.

For Excel 2007, click the Microsoft Role Push button , then Excel Options.
So click Advanced > Brandish > clear or select the Evidence all windows in the Taskbar check box.

Hibernate or unhide a worksheet

Select the worksheets that you desire to hide.

How to select worksheets

To select	Do this
A unmarried canvas	Click the sheet tab. If you don't see the tab that you want, click the scrolling buttons to the left of the sheet tabs to brandish the tab, and and then click the tab.
Two or more adjacent sheets	Click the tab for the showtime sheet. Then hold downwardly Shift while you click the tab for the last canvass that you desire to select.
2 or more nonadjacent sheets	Click the tab for the outset sail. Then hold downward Command while you click the tabs of the other sheets that y'all want to select.
All sheets in a workbook	Right-click a sheet tab, and then click Select All Sheets on the shortcut menu.

On the Dwelling house tab, click Format > under Visibility > Hide & Unhide > Hide Sail.
To unhide worksheets, follow the aforementioned steps, but select Unhide. The Unhide dialog box displays a list of hidden sheets, so select the ones you want to unhide and and then select OK.

Hide or unhide a workbook window

Click the Window menu, click Hide or Unhide.

Notes:

When you Unhide a workbook, select from the list of hidden workbooks in the Unhide dialog box.
If Unhide is unavailable, the workbook does not incorporate hidden workbook windows.
When you exit Excel, you lot will be asked if you want to save changes to the hidden workbook window. Click Yes if you desire the workbook window to exist the same as you left information technology (hidden or unhidden) the next time that you open up the workbook.