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