excel microsoft training - Creating groups and outlines

The UK's most regular instructor-led training courses.
Training information: excel microsoft training · Excel in courses · Microsoft Excel Training London
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Creating groups and outlines

Tamara has attended:
Excel Intermediate course

by - delegate Tamara [1 post] (2008 Jan 23 Wed, 16:34) Reply

Where do you start/ what do you select in order to create a group.

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2009 Jan 9 Fri	Bloomsbury	1	book now	£240	£245
2007	2009 Jan 14 Wed	Bloomsbury	5	book now	£235	£245
2002/XP	2009 Jan 14 Wed	Tooting	0	FULL
2003	2009 Jan 16 Fri	Southwark	0	FULL
2007	2009 Jan 21 Wed	Bloomsbury	3	book now	£240	£245
2003	2009 Jan 21 Wed	Southwark	2	book now	£235	£240
Full Schedule: See all 114 Excel Advanced course dates. Bookings currently available until 31st March 2010.

RE: Creating groups and outlines

by - trainer Amanda diamond contributer [1297 posts] (2008 Jan 29 Tue, 14:53) Reply

Hi Tamara

Thank you for your question - apologies for the delay in replying. I hope you haven't had any problems with using the outline feature in the meantime.

To create an automatic outline, select the data that you wish to apply the outline to. Then go to Data - Group and Outline - Auto Outline. If Excel can create an automatic outline from your selected data, it will.

If this doesn't work, or you want to group only specific rows or columns within your spreadsheet, then you select the rows or columns you wish to group, then go to Data - Group and Outline - Group. An outline area will appear at the top or side of your screen (depending if you've grouped rows or columns) and you will be able to collapse and expand your group using the outline area.

I hope this is useful.
Amanda

· Microsoft Excel Cheat Sheet: Tips and Shortcuts
· Excel Macros for the Non-Programmer
· Fun Things I've Done With Excel
· Excel in the Home Office
· Crazy Things People Have Done With Excel

Excel tip:

Move data worksheet to worksheet

To move data from one worksheet to another, highlight the data.

Select and hold down the ALT key and position the mouse on the border of the selection until the mouse pointer displays four-headed arrows.

Drag the selection down to the destination worksheet tab.

When the arrow touches the tab, Excel switches to the desired worksheet. Now drag the selection to the correct position. Let go of the mouse and then the ALT key.

To copy data from one worksheet to another, select and hold down the CTRL+ALT keystroke combination and perform the steps above.

View all Excel hints and tips

Rate this page: