Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
H,
I've used the grouping function in the past to make a series of columns collapsable. This has been very useful for reading and cross referencing in documents with lots of columns. Now I have a document with few columns, but each column is very wide. I want to give column its own plus and minus button so that I can close any column, or selection of columns, as I need. If I try to do this, unsurprisingkly with a feature called "group", all the columns are added to the first plus/minus button. Is there any way that I can give each column its own plus/minus button? Thanks Karl |
#2
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
I don't know of any way to do so short of VBA, at least as far as the +/-,
but don't overlook the FormatColumnHide/Unhide capability. You might even create macros & assign them to buttons on a custom toolbar. You can also create custom Views & add a list of views to a toolbar so you can go directly from one to another. -- HTH |:) Bob Jones [MVP] Office:Mac "Karl" wrote in message ... H, I've used the grouping function in the past to make a series of columns collapsable. This has been very useful for reading and cross referencing in documents with lots of columns. Now I have a document with few columns, but each column is very wide. I want to give column its own plus and minus button so that I can close any column, or selection of columns, as I need. If I try to do this, unsurprisingkly with a feature called "group", all the columns are added to the first plus/minus button. Is there any way that I can give each column its own plus/minus button? Thanks Karl |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I wrap Excel columns in a printout? | Excel Discussion (Misc queries) | |||
How do i copy columns of data in notepad into microsoft excel? | Excel Discussion (Misc queries) | |||
How do i copy columns of data in notepad into microsoft excel? | Excel Discussion (Misc queries) | |||
How do i copy columns of data in notepad into excel? | Excel Discussion (Misc queries) | |||
Columns in Excel will not allow user to click in them | Excel Discussion (Misc queries) |