Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Karl
 
Posts: n/a
Default Grouping columns in excel

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   Report Post  
Posted to microsoft.public.excel.newusers
CyberTaz
 
Posts: n/a
Default Grouping columns in excel

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I wrap Excel columns in a printout? R2 Excel Discussion (Misc queries) 1 April 1st 06 09:47 AM
How do i copy columns of data in notepad into microsoft excel? Jason Excel Discussion (Misc queries) 3 February 12th 05 02:04 AM
How do i copy columns of data in notepad into microsoft excel? Jason Excel Discussion (Misc queries) 1 February 10th 05 11:05 PM
How do i copy columns of data in notepad into excel? JJ Excel Discussion (Misc queries) 1 February 10th 05 09:21 PM
Columns in Excel will not allow user to click in them Kim Excel Discussion (Misc queries) 1 December 28th 04 06:37 PM


All times are GMT +1. The time now is 01:54 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"