The Unhide dialog box displays a list of hidden sheets, so select the ones you want to unhide and then select OK.Ĭlick the Window menu, click Hide or Unhide. It is easy to hide sheets in Excel, but probably unhide multiple worksheets at once would be not so easy to do, if you cannot find an effective way. 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. All it does it let you know that there are some hidden rows in the sheet. Setting the visible property to False hides the sheet, setting it to True unhid. You can see the Unhide Rows option, but you cant click on it. The most important take-away here is that the the visibility of a worksheet is controlled by the visible property of the Worksheet object. Then hold down Command while you click the tabs of the other sheets that you want to select. Answer (1 of 4): There are already a couple of good answers to this question. 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. Excel lets you hide multiple worksheets (or tab) by giving you the option to group them first (Press Shift and right mouse click to choose the Hide command).
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.
0 kommentar(er)
