| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
hiding the worksheet
I need to know how to hide a worksheet within the excel workbook. any body
can help me? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
hiding the worksheet
With the worksheet on screen, click ~Format ~Sheet ~Hide.
|
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
hiding the worksheet
Click on "Format", "Sheet", "Hide". This will hide the worksheet.
"Narnimar" wrote: I need to know how to hide a worksheet within the excel workbook. any body can help me? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
hiding the worksheet
Narnimar
Another way... right click on the tab you want to hide and select "Hide" Mike Rogers "Narnimar" wrote: I need to know how to hide a worksheet within the excel workbook. any body can help me? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
hiding the worksheet
Mike
This is not native to Excel before 2007 version and I don't know if possible in 2007. Do you have a "Hide" command added to the sheet tab right-click menu? Gord Dibben MS Excel MVP On Thu, 28 Dec 2006 07:16:01 -0800, Mike Rogers wrote: Narnimar Another way... right click on the tab you want to hide and select "Hide" Mike Rogers "Narnimar" wrote: I need to know how to hide a worksheet within the excel workbook. any body can help me? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
hiding the worksheet
Gord
So it only takes me six months to get back to you on this comment. 3 As a matter of fact I do have "Hide on my Sheet tab right click menu. Just went and checked again and it is there. There is not an Unhide tho for that I have to goto format....etc. I am using 2000 student/teacher edition, I do have several addins that I have accumulated through the years, maybe it is from one of them. Interesting Mike Rogers -- The only dumb question is the one you did not ask. "Gord Dibben" wrote: Mike This is not native to Excel before 2007 version and I don't know if possible in 2007. Do you have a "Hide" command added to the sheet tab right-click menu? Gord Dibben MS Excel MVP On Thu, 28 Dec 2006 07:16:01 -0800, Mike Rogers wrote: Narnimar Another way... right click on the tab you want to hide and select "Hide" Mike Rogers "Narnimar" wrote: I need to know how to hide a worksheet within the excel workbook. any body can help me? |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
hiding the worksheet
And my Excel add-in "XL Extras" is one of those that do. It also provides an "Unhide All" command on the Format |Sheet menu. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Mike Rogers" <Mike060349@NoxSpamxAOLDOTcom wrote in message Gord So it only takes me six months to get back to you on this comment. 3 As a matter of fact I do have "Hide on my Sheet tab right click menu. Just went and checked again and it is there. There is not an Unhide tho for that I have to goto format....etc. I am using 2000 student/teacher edition, I do have several addins that I have accumulated through the years, maybe it is from one of them. Interesting Mike Rogers -- The only dumb question is the one you did not ask. "Gord Dibben" wrote: Mike This is not native to Excel before 2007 version and I don't know if possible in 2007. Do you have a "Hide" command added to the sheet tab right-click menu? Gord Dibben MS Excel MVP On Thu, 28 Dec 2006 07:16:01 -0800, Mike Rogers wrote: Narnimar Another way... right click on the tab you want to hide and select "Hide" Mike Rogers "Narnimar" wrote: I need to know how to hide a worksheet within the excel workbook. any body can help me? |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
hiding the worksheet
Thanks for the feedback Mike.
One of those add-ins must be putting the "Hide" command on the sheet right-click menu. To find it, do a search on "Ply" which is the name of the sheet right-click menu. Gord On Tue, 10 Jul 2007 20:38:03 -0700, Mike Rogers <Mike060349@NoxSpamxAOLDOTcom wrote: Gord So it only takes me six months to get back to you on this comment. 3 As a matter of fact I do have "Hide on my Sheet tab right click menu. Just went and checked again and it is there. There is not an Unhide tho for that I have to goto format....etc. I am using 2000 student/teacher edition, I do have several addins that I have accumulated through the years, maybe it is from one of them. Interesting Mike Rogers |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
hiding the worksheet
Gord
I think Jim hit the nail on the head.... I do have his addin employed, thanks Jim!!! Now I have to be careful and keep track of what does what and who it is from <g . Thanks guys!! Mike Rogers -- The only dumb question is the one you did not ask. "Gord Dibben" wrote: Thanks for the feedback Mike. One of those add-ins must be putting the "Hide" command on the sheet right-click menu. To find it, do a search on "Ply" which is the name of the sheet right-click menu. Gord On Tue, 10 Jul 2007 20:38:03 -0700, Mike Rogers <Mike060349@NoxSpamxAOLDOTcom wrote: Gord So it only takes me six months to get back to you on this comment. 3 As a matter of fact I do have "Hide on my Sheet tab right click menu. Just went and checked again and it is there. There is not an Unhide tho for that I have to goto format....etc. I am using 2000 student/teacher edition, I do have several addins that I have accumulated through the years, maybe it is from one of them. Interesting Mike Rogers |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Autodate worksheet tab | Excel Discussion (Misc queries) | |||
| Retrieve data from all of the worksheet within the file | Excel Worksheet Functions | |||
| Search/Match between 2 x separate Worksheets and populate result in third worksheet | Excel Discussion (Misc queries) | |||
| Protected worksheet, showing and hiding Grouped detail | Excel Discussion (Misc queries) | |||
| Weekly Transaction Processing | Excel Worksheet Functions | |||
Hybrid Mode
