Hide and show worksheets in Excel

Contents
  1. Don’t worry, hidden sheets will not be deleted
  2. Using data in hidden worksheets
  3. Hide worksheets from the context menu
  4. Hide a sheet
  5. Hide multiple worksheets
  6. Hide sheets with ribbon
  7. Display worksheets using the context menu
  8. Show sheets with ribbon

Don’t worry, hidden sheets will not be deleted

An Excel worksheet is a single spreadsheet of cells. Each cell can contain text, a number, or a formula, and each cell can refer to another cell in the same worksheet, workbook, or workbook.

By default, all open Excel workbooks display sheet tabs in the taskbar at the bottom of the screen, but you can hide or show them if you want. At least one sheet must always be visible.

These instructions apply to Excel 2019, 2016, 2013, 2010, and Excel for Office 365.

Using data in hidden worksheets

Hiding worksheets doesn’t mean you’re deleting them, and you can still reference them in formulas and charts on other worksheets or other workbooks.

Hide worksheets from the context menu

Options available in contextual menu – context menu – change depending on what is selected.

If the parameter Hide is inactive or gray, there is most likely only one sheet in the current workbook. disable excel option Hide for single sheets, because at least one sheet must always be visible.

Hide a sheet

  1. Press sheet tab to select it.

  2. Right click on the sheet tab to open context menu

  3. IN menu Select option Hide to hide the selected sheet.

Hide multiple worksheets

  1. Press tab the first sheet you want to hide to select it.

  2. Press and hold key ctrl on keyboard.

  3. Click tabs additional sheets to select them.

  4. Right click on the single sheet tab to open context menu

  5. IN menu Select option Hide to hide all selected sheets.

Hide sheets with ribbon

Excel does not have a keyboard shortcut to hide worksheets, but you can use the ribbon bar to perform the same task.

  1. Choose one or more sheet tabs at the bottom of the Excel file.

  2. Press House tab on the adhesive tape

  3. Choose an icon Format

  4. Click Hide and show

  5. Select Hide sheet

Display worksheets using the context menu

You can display tabs with context menu just like you can hide them.

  1. Right click on the sheet tab to open the dialog Show which displays all currently hidden sheets.

  2. Press sheet you want to display.

  3. Click Okay to display the selected sheet and close the dialog box.

Show sheets with ribbon

As with hidden sheets, Excel doesn’t have a keyboard shortcut to display a sheet, but you can still use the ribbon.

  1. Choose one or more sheet tabs at the bottom of the Excel file.

  2. Press House tab on the adhesive tape

  3. Select Format

  4. Click Hide and show

  5. Select Show sheet

  6. Click on sheet The one you want to appear in the drop-down list.

  7. Click Okay

Leave a Reply

Your email address will not be published. Required fields are marked *