microsoft excel - grouping excel

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

TrustPilot

starstarstarstarstar Excellent

  • 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 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


Server loaded in 0.08 secs.