Note, there is no indication that a worksheet is hidden. Select the worksheet you'd like to unhide, and click OK. To unhide a worksheet, right-click on a visible tab, then choose Unhide from the menu.Įxcel will display a list of all hidden worksheets. You can hide as many worksheets as you like, but there must be at least one worksheet visible in the workbook. The hidden worksheet won't appear in the pop-up menu either. The worksheet will disappear, and the tab will no longer be visible at the bottom. The easiest way to hide a worksheet is to right-click the worksheet tab and choose Hide from the menu. Here we have a workbook that contains one worksheet for users to enter data and a reference worksheet that contains a lookup table. You might want to hide worksheets that contain calculations, notes, or lookup data that is not normally needed.Īs you build more complicated workbooks, you might want to hide certain worksheets to keep things simple. In this lesson, we'll look at how to hide and unhide worksheets.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
June 2023
Categories |