creating outlines

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Creating Outlines

Creating Outlines

resolvedResolved · Low Priority · Version 2003

Christiane has attended:
Excel Intermediate course

Creating Outlines

Hopw do I create manual outlines?

RE: Creating Outlines

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


 

Excel tip:

Creating custom lists

In Excel if you type in January in a cell, you can then copy this cell to replicate Febraury, MArch, April etc.

This list has come from Tools- options and Custom lists.

Therefore to save time and create your own list you can click on New (in Tools and custom list tab) and type out the lsit that you want copied quickly.

All you have to do is then type in the 1st word and you will be able to copy the rest of the list quickly.

View all Excel hints and tips


Server loaded in 0.08 secs.