Column grouping

P

philcart

Board Regular
Joined
Feb 12, 2003
Messages
177
Hi,
I’m not sure this can be done, and haven’t been able to find a solution on the Board, but here goes -
I have a worksheet in which I have grouped 2 sets of columns to make for easier viewing of the essential data.
Group 1 hides/unhides cols 4 – 14, Group 2 hides/unhides cols 16 – 30, Group 3 shows all columns.
The Group buttons in the top left corner are labelled 1, 2, and 3. Is there any way of changing these labels to something more meaningful to the user?
Any help gratefully received.
Phil
 

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)
Sort by date Sort by votes
AFAIK that is not possible ... still if I'm wrong and it is possible to modify the labels I too would like to know how it's done.
 
Upvote 0
Many thanks for taking the time to reply. Hopfully someone might have an answer, but I suspect you are right.

Phil
 
Upvote 0
The only way I can think of solving this would be to add a button(Tools/Customize/Commands/Forms) to your sheet and run some code on the press of the button. Button can be labelled whatever you like to assist The following will toggle hide/unhide of columns D to N (4 - 14 as per your group 1), just ammend for your data sets:

Code: 
Private Sub ViewData_Click()
Sheet1.Columns("D:N").EntireColumn.Hidden = _
Not Sheet1.Columns("D:N").EntireColumn.Hidden
End Sub

Add aditional buttons for your other groups.....

Hope this helps??
 
Upvote 0
You must log in or register to reply here.

Similar threads

C
  • Solved
Transposing Columns to Rows
2
Replies
10
Views
194
Fluff
Fluff
T
  • Question Question
Pull data from every 5th column based on dropdown selection
Replies
4
Views
245
Twinky
T
V
  • Solved
Creating a new filtered list from a dynamically created list based on previous numbers
Replies
6
Views
98
DanteAmor
DanteAmor
S
  • Question Question
Hide / unhide columns without using macros / VBA
Replies
1
Views
558
JEC
JEC
M
  • Question Question
Need multiple buttons to hide/show rows on another tab
Replies
8
Views
818
skillilea
S

Forum statistics

Threads
1,223,228
Messages
6,170,871
Members
452,363
Latest member
merico17

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top