Creating Outlines

Resolved · Low Priority · Version 2003

Creating Outlines

Christiane has attended:
Excel Intermediate course

by - delegate Christiane [1 post] (2008 Jul 1 Tue, 16:44) Reply

Hopw do I create manual outlines?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 25 Tue	Bloomsbury	0	FULL
2003	2008 Nov 27 Thu	Southwark	3	book now	£210	£215
2007	2008 Nov 28 Fri	Bloomsbury	0	FULL
2003	2008 Dec 2 Tue	Bloomsbury	3	book now	£210	£215
2003	2008 Dec 4 Thu	Bayswater	6	book now	£195	£205
2007	2008 Dec 8 Mon	Bayswater	5	book now	£212	£224
Full Schedule: See all 113 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: Creating Outlines

by - trainer Martin bronze contributer [27 posts] (2008 Jul 17 Thu, 12:48) Reply

Hi Christiane,

What you need to do is highlight what you want to put into a group, and then go to Data / Group and Outline / choose group. You can do this as many times as you want if you don't want to use the auto outline option. If you need to remove the outlines then highlight the rows or columns you used to create the then go to Data / Group and Outline / choose ungroup.

Hope that helps
Regards
Martin

· Microsoft Excel Training Course
· Microsoft Excel Courses Teach Advanced Macro Techniques
· Tools From Advanced Excel Courses: Goal Seek and Solver
· Interesting Lifestyle Applications for Microsoft Excel
· Microsoft Excel Features and Functions for Accountants

Please browse our web site to find out more about
excel one day course london and other Microsoft training courses.

Excel tip:

Deleting a range of cells using the autofill handle

Firstly, select the range of cells for which you would like to clear the contents. Then drag the autofill handle to the the top left corner of the selection whilst holding down the shift key. Your selected contents should then be deleted.

View all Excel hints and tips

Rate this page: