microsoft excel - grouping excel

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

Train Strikes - 7th, 12th Nov 2024
Hide
Contact Us About Resources Consent preferences Sign in

TrustPilot

starstarstarstarstar Excellent

Request Callback We will call you back  0207 987 3777 Call for assistance Your Basket Basket is empty
Callback Sign in Basket
Menu

Call us on 0207 987 3777 or Search our website

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

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

microsoft excel - Grouping in excel

resolvedResolved · Low Priority · Version Standard

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

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.

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

Excel tip:

Screen Splitters in Excel

Screen splitter icons can be set from the ribbon bar, or dragged from the scroll bars. The icon just above the up arrow on the right scroll bar controls the horizontal splitter; the icon to the right of the right arrow on the bottom scroll bar controls the vertical splitter.

These icons can be double-clicked to split the screen at the top left of the cell currently in use.

View all Excel hints and tips


Request Callback

We will call you back

0207 987 3777

Call for assistance

Security verified Microsoft Partner

Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE

2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom

Terms & Conditions Privacy & Cookie Policy Consent preferences

Server loaded in 0.08 secs.