Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

groupungroup heading grouped

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Group/ungroup - heading for grouped columns?

Group/ungroup - heading for grouped columns?

ResolvedVersion 2007

Jess has attended:
Excel Intermediate course
Excel Advanced course

Group/ungroup - heading for grouped columns?

Hi there

I have a spreadsheet where I am grouping columns into several groups. Is it possible to lable each group so when others look at the spreadsheet they know which columns to expand?

Thanks

RE: Group/ungroup - heading for grouped columns?

Hi Jess, thanks for your query. There's no way to attach a label to the grouping graphic itself - that's hardwired into the Application - but what most people do is make sure a heading is still visible when the group is collapsed, so the users know what to expect when they click on the + sign on the group.

Hope this helps,

Anthony

Tue 21 Dec 2010: Automatically marked as resolved.

Excel tip:

Working with 3D formulas

You can only use fill-down if you remove $ for Absolute References.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.