Click OK. Actively scan device characteristics for identification. Use precise geolocation data. Select personalised content. Create a personalised content profile. Measure ad performance. Select basic ads.
Create a personalised ads profile. Select personalised ads. Apply market research to generate audience insights. Measure content performance. Develop and improve products. List of Partners vendors. Ted French. Former Lifewire writer Ted French is a Microsoft Certified Professional who teaches and writes about spreadsheets and spreadsheet programs. Updated on January 01, Tweet Share Email.
What to Know Easiest way to hide a worksheet: right-click the worksheet tab and select Hide. Easiest way to unhide: right-click any worksheet tab, select Unhide , and select worksheet to unhide.
Was this page helpful? Thanks for letting us know! Email Address Sign up There was an error. Then hold down Command while you click the tabs of the other sheets that you want to select. The Unhide dialog box displays a list of hidden sheets, so select the ones you want to unhide and then select OK. Click the Window menu, click Hide or Unhide. Click Yes if you want the workbook window to be the same as you left it hidden or unhidden the next time that you open the workbook. You can always ask an expert in the Excel Tech Community or get support in the Answers community.
Hide or show rows or columns. Enter and format data. Hide or unhide a worksheet Note: The screen shots in this article were taken in Excel Notes: When you Unhide a workbook, select from the list in the Unhide dialog box.
Hide or unhide a worksheet Select the worksheets that you want to hide. How to select worksheets To select Do this A single sheet Click the sheet tab. Two or more adjacent sheets Click the tab for the first sheet.
Two or more nonadjacent sheets Click the tab for the first sheet. All sheets in a workbook Right-click a sheet tab, and then click Select All Sheets on the shortcut menu. Hide or unhide a workbook window Click the Window menu, click Hide or Unhide. Notes: When you Unhide a workbook, select from the list of hidden workbooks in the Unhide dialog box. Need more help?
Expand your skills. Get new features first. Was this information helpful? Yes No. This setting remains intact when you save the workbook and reopen it again, or send it to some else. This will hide all the worksheets at one go. Note that you can only unhide one sheet at a time. To unhide multiple sheets, you need to repeat the above steps to unhide each worksheet. Alternately, you can use a macro code to unhide all the worksheets at one go.
All they need to do is right-click on any of the tabs and they will see what all worksheets are hidden and unhide these easily. When you right-click on any of the tabs, you will not see it in the list of hidden sheets that you can unhide. The above code would hide all the worksheet except the except the active sheet. However, it will hide it so that these can be unhidden easily note that ws. Visible property is set to xlSheetHidden.
0コメント