groupungroup heading grouped
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

Group/ungroup - heading for grouped columns?

resolvedResolved · Medium Priority · Version 2007

replyReply Wed 15 Dec 2010, 14:24Delegate Jess said...

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

For upcoming training course dates see: Pricing & availability

replyReply Wed 15 Dec 2010, 15:45Trainer Anthony said...

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.

 

Please browse our web site to find out more about
excel consulting and other Microsoft training courses.

Excel tip:

Quickly hide and unhide rows and columns

Use the keyboard shortcut Ctrl+9 to hide selected rows and Ctrl+0 to hide selected columns. The good thing about this shortcut is that you do not need to select entire rows or columns. For example, select B3:D3 then press Ctrl+0 to hide columns B to D.

Ctrl+Shift+9 unhides rows and Ctrl+Shift+0 unhides columns.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard