Any way to determine width of Data Group panel

J

jkmblogs

New Member
Joined
Mar 28, 2012
Messages
19
In excel, when you group:
  • rows, data grouping levels are shown in a frame to the left of row numbers
  • columns, data grouping levels are shown in a frame above column letters

Is there a way to determine the width of the frame added to excels window?
 

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!
You must log in or register to reply here.

Similar threads

Q
  • Solved
VBA: Dynamically Create Active X Frame and Yes / No Radio Button
2
Replies
13
Views
174
Domenic
D
tazeo
  • Question Question
Hierarchical Table to a PivotTable (or something similar)
Replies
0
Views
63
tazeo
tazeo
L
  • Question Question
Macro to correct entries across multiple sheets
Replies
1
Views
186
Lux Aeterna
L
C
  • Question Question
Adding New Data to Table with Inconsistent Entries Using VBA
Replies
0
Views
187
Curious George_1
C
E
  • Question Question
Does Excel have anything like Smartsheet's Hierarchy (Parent/Child rows)?
Replies
3
Views
2K
Edgar_
Edgar_

Forum statistics

Threads
1,223,888
Messages
6,175,215
Members
452,618
Latest member
Tam84

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