Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
If your post can be interpreted literally...meaning that you want a button to
hide/unhide entire columns... Try this: Select columns D,E, and F From the Excel main menu: <data<group and outline<Group That will display a [-] button above the worksheet. Clicking on that button hides the columns and changes the button to [+] Click on the [+] button to redisplay the columns. Post back with any questions. Does that help? *********** Regards, Ron XL2002, WinXP "Shoolin Patel" wrote: I want to setup or enter a function in a cell that will allow me to use that cell as a "button". I want to setup this cell so that when I click on it, it will hide selected cells. For example: Clicking on cell "A1" allows me to hide columns D,E and F. I'd appreciate any kind of help on this. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Cells are selected but aren't displayed as selected | Excel Discussion (Misc queries) | |||
A validated List which link to selected cells according to what is selected on the list | Excel Worksheet Functions | |||
Excluding selected cells in excel | Excel Discussion (Misc queries) | |||
Can I create an Excel chart from non-contiguous data cells? | Charts and Charting in Excel | |||
How can I create a drop down list from non-adjacent cells | Excel Discussion (Misc queries) |