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

excel in courses - worksheet

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel in courses - Worksheet

excel in courses - Worksheet

ResolvedVersion Standard

Monika has attended:
Excel Intermediate course

Worksheet

how to create outline worksheet?

RE: worksheet

Hi Monika

To create an outline, select the data you want to outline, then choose DATA, then GROUP AND OUTLINE, then AUTO OUTLINE.

This will evaulate your data on outline to it best ability.

You could also manually GROUP the relevant rows or columns by doing the following:
select the data you want to outline, then choose DATA, then GROUP AND OUTLINE, then GROUP.

Excel tip:

Using an equal (=) sign that isn't part of a formula

Before you type the equal sign, type an apostrophe: '
Then type your equal sign: = (and anything else you want to add after your equal sign)
Press ENTER.

(the apostraphe will disappear

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.12 secs.