excel in courses - worksheet

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

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

excel in courses - Worksheet

resolvedResolved · Low Priority · Version 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 Alt in Save Dialog Box

When you are saving (or opening) a file, try these;
(Note the numbers are on the keyboard not the numeric keypad)
1. Go to previous folder Alt+1
2. Go up one folder level Alt+2
3. Search the Web Alt+3
4. Delete selected file Alt+4 or Delete
5. Create a new folder Alt+5
6. Cycle through all views Alt+6 repeatedly
7. Display the Tools menu Alt+7

View all Excel hints and tips


Server loaded in 0.08 secs.