To unhide worksheets, follow the same steps, but select Unhide. On the Home tab, click Format > under Visibility > Hide & Unhide > Hide Sheet. Right-click a sheet tab, and then click Select All Sheets on the shortcut menu. Then hold down Command while you click the tabs of the other sheets that you want to select.
Then hold down Shift while you click the tab for the last sheet that you want to select.Ĭlick the tab for the first sheet. If you don't see the tab that you want, click the scrolling buttons to the left of the sheet tabs to display the tab, and then click the tab.Ĭlick the tab for the first sheet.
Select the worksheets that you want to hide.
