ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   hide worksheet (https://www.excelbanter.com/excel-discussion-misc-queries/39859-hide-worksheet.html)

Ankur

hide worksheet
 
is there any way to hide worksheets in a workfile for eg - i have to hide 5
to 8 worksheet in a workfile consisting of 10 worksheet.

Doug Kanter


"Ankur" wrote in message
...
is there any way to hide worksheets in a workfile for eg - i have to hide
5
to 8 worksheet in a workfile consisting of 10 worksheet.


Yes, there is, and it's simple & clearly labeled. Explore the Excel menus
until you find the word "Hide". Or, press F1 for the Help system and search
for the word "Hide".



Alan

Yes there is, on the top toolbar, Format Sheet Hide. If you want to
prevent users unhiding them, password protect the workbook.
Note that Excel protection is weak and easily overcome by an experienced
user who has the will to do so,
Regards,
Alan.
"Ankur" wrote in message
...
is there any way to hide worksheets in a workfile for eg - i have to hide
5
to 8 worksheet in a workfile consisting of 10 worksheet.





All times are GMT +1. The time now is 04:31 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com