![]() Open VBA editor with Alt + F11 keyboard shortcut.Ģ. With “ Visible” attribute in VBA editor, you can hide and unhide worksheets in Excel through attribute changes.ġ. Method 2: Hide/Unhide Worksheets with VBA Later, when you need to unhide all the hidden worksheets, you would just have to choose Unhide instead of Hide option with the same progress one by one. Click on the first worksheet tab and hold down the Shift key as you click on the last worksheet tab, and then do like above when you hide single sheet. ![]() Hold on Ctrl button and choose all the worksheets tabs one by one you want to hide, and choose Hide option in right menu.Ģ. If you want to hide multiple worksheets at once, just need to make full use of “ Ctrl” or “ Shift” button here, then all of selected worksheets would be hidden at a time.ġ. Then do the same to hide every worksheet you wish. Or right click the worksheet tab and choose “ Hide” option, you could hide single one sheet. On the Home tab, choose “ Format > Hide and Unhide” and select “ Hide Sheet“. ![]() But as long as you are familiar with MS Excel, you would know the common Hide and Unhide Sheet command in Excel. 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. 3 Methods to Hide or Unhide One or Multiple Sheets in Excel 2016-2007ĭo you want to hide sheets for protection or unhide hidden worksheets for visible in Excel 2016/2013/2010/2007? Here 3 effective methods would be talked about in this passage and you can learn how to hide or unhide worksheets in Excel with them. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |