Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
"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". |
#3
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hide a worksheet so that a macro can still find it | Excel Worksheet Functions | |||
Hide AutoShapes On Excel Worksheet | Excel Worksheet Functions | |||
How do I automatically hide columns in a worksheet based on a cell value? | Excel Worksheet Functions | |||
how to hide section of worksheet based on a condition (e.g. tick . | Excel Discussion (Misc queries) | |||
How do I hide a worksheet in Excel and use a password to un-hide . | Excel Discussion (Misc queries) |