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

outline

ResolvedVersion 2003

Nicole has attended:
Excel Intermediate course
Outlook Advanced course
Excel Advanced course
PowerPoint Intermediate Advanced course

Outline

Hi I can't remember how to outline a worksheet? can you explain please.

Thanks

RE: Outline

Hi Nicole

Thank you for your question.

To create an automatic outline:
1. Select the area of the spreadsheet that you want to include in the outline.

2. Go to Data - Group and Outline - Auto Outline

If Excel can create an outline automatically from your data it will.

You can also manually create an outline if this doesn't work. For information on this, look up outline in Excel help.

Amanda

Excel tip:

Copying Formulae Quickly

There is a quicker way of copying a formula down a column.

Just point and double click on the black autofill handle in the right hand corner of a cell.

This will work providing you have some data in the column to the left of the column.

Sandy

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.