AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
![]() ![]() 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. 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. If you only want to unhide certain sheets then the following should do exactly that. Sub UnhideMe () Unhide all of the sheets which are hidden in an Excel file. 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. The following lines of VBA code will unhide all sheets in a workbook. 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 Comments
Read More
Leave a Reply. |