Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel - Grouping in excel

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

microsoft excel - Grouping in excel

Resolved · Low Priority · Version Standard

Reply Fri 26 Oct 2007, 12:26Delegate Chris said...

Chris has attended:
Excel Advanced course

Grouping in excel

Hi,

I have a spreadsheet that I had some groups on, so I could quickly present different bits of data. Now the groups have gone, and the sheet won't allow me to add new ones. Very strange. Any ideas?

Thanks,

Chris

For upcoming training course dates see: Pricing & availability

Reply Sun 28 Oct 2007, 01:06Trainer Rajeev said...

RE: Grouping in excel

Dear Chris

Thank you for joining our Excel Adv course. I hope you enjoyed it and benefited from the course.

Outline is a topic that is not very straightforward.

By the sounds of it it looks like that the option in the Tools> options... in the view tab Outlines Symbols tab is unchecked!

If you check it then the problem should be resolved!! This might have happened when you might have tried to use some sort of shortcut key or used the keyboard shortcut by mistake!!

I hope this resolves your problem.

Reply Sun 28 Oct 2007, 16:59Trainer Rajeev said...

RE: Grouping in excel

Dear Chris

I managed to find the shortcut key to the menu command that I suggested in my previous message.

Try CTRL+8.

It is a possibility that you might have used this shortcut key by mistake which might have switched off the grouping and outline options!!

If this has helped you resolve the problem please check it as resolved!!
I hope this has helped!!

Thanks

Rajeev Rawat
Microsoft Office Specialist Master Instructor

Excel articles

· How to Create Better Excel Spreadsheets: Part Four
· Using Excel In Any Condition
· Microsoft Excel as a Reporting Tool
· 3 Reasons why Your Small Business Office Needs Microsoft Excel Training
· How To Create Formulas In Excel

Excel tip:

Calculate difference between two times

For presenting the result in the standard time format (hours : minutes : seconds . Use the subtraction operator (-) to find the difference between times, and the TEXT function to format the returned value to text in a specific number format.

Hours never exceed 24, minutes never exceed 60, and seconds never exceed 60.

=TEXT(B2-A2,"h")
Hours between two times (4)

=TEXT(B2-A2,"h:mm")
Hours and minutes between two times (4:55)

=TEXT(B2-A2,"h:mm:ss")
Hours and seconds between two times (4:55:00)

Where B2 and A2 must hold the end time and start time respectively formatted as a time format

View all Excel hints and tips