Software & Apps MS Office How to Hide and Unhide Worksheets in Excel Don't worry, hidden worksheets are not deleted by Ted French Writer Former Lifewire writer Ted French is a Microsoft Certified Professional who teaches and writes about spreadsheets and spreadsheet programs. our editorial process Ted French Updated on November 13, 2019 MS Office Excel Word Powerpoint Outlook Tweet Share Email An Excel worksheet is a single spreadsheet that contains cells. 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. By default, all open Excel workbooks display worksheet tabs on the taskbar at the bottom of the screen, but you can hide or display them as needed. At least one worksheet must be visible at all times. These instructions apply to Excel 2019, 2016, 2013, 2010, and Excel for Microsoft 365. Data Use in Hidden Worksheets Hiding worksheets doesn't mean you're deleting them, and you can still reference them in formulas and charts located on other worksheets or other workbooks. Hide Worksheets Using the Contextual Menu The options available in the contextual menu — the right-click menu — change depending on what is selected. If the Hide option is inactive or grayed out, most likely the current workbook has only one worksheet. Excel deactivates the Hide option for single-sheet workbooks because there must always be at least one visible sheet. How to Hide a Single Worksheet Click the worksheet tab to select it. Right-click on the worksheet tab to open the contextual menu. In the menu, click the Hide option to hide the selected worksheet. How to Hide Multiple Worksheets Click the tab of the first worksheet to be hidden to select it. Press and hold down the Ctrl key on the keyboard. Click the tabs of additional worksheets to select them. Right-click on one worksheet tab to open the contextual menu. In the menu, click on the Hide option to hide all the selected worksheets. Hide Worksheets Using the Ribbon Excel has no keyboard shortcut for hiding worksheets, but you can use the ribbon bar to accomplish the same task. Select one or more worksheet tabs at the bottom of an Excel file. Click the Home tab on the ribbon. Select the Format icon. Click on Hide & Unhide. Select Hide Sheet. Unhide Worksheets Using the Contextual Menu You can unhide tabs using the contextual menu, just as you can hide them. Right-click a worksheet tab to open the Unhide dialog box, which displays all the currently hidden sheets. Click the sheet you want to unhide. Click OK to unhide the selected worksheet and to close the dialog box. Unhide Worksheets Using the Ribbon As with hiding worksheets, Excel has no keyboard shortcut for unhiding a sheet, but you can still use the ribbon. Select one or more worksheet tabs at the bottom of the Excel file. Click the Home tab on the ribbon. Select Format. Click Hide & Unhide. Select Unhide Sheet. Click the sheet you want to unhide from the list that pops up. Click OK.