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. |