excel-training-course - 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 » excel-training-course - Creating outlines

excel-training-course - Creating outlines

resolvedResolved · Low Priority · Version Standard

Richard has attended:
Excel Intermediate course
Excel Introduction course

Creating outlines

How do you go about creating outlines?

RE: Creating outlines

hi Richard,

Thanks for your question.

To add group outlines, you may either set Auto outline or Group data manually.

Auto:
1) Select a cell from the data table
2) Click on Data menu > Group and Outline
3) Auto-Outline (Clear Outline to cancel outline)

Manual:
1) Select rows/columns to be gouped
2) Clicon on Data menu > Group and Outline
3) Group (unGroup to clear outline)

Hope this helps.

Regards,

Katie


 

Excel tip:

Edit and format multiple worksheets in one operation

To select two or more non-adjacent worksheets, click on the tab of each worksheet, while holding down the [CTRL] key.
To select two or more adjacent worksheets, click on the tab of the first worksheet and then on the tab of the last worksheet, while holding down the [SHIFT] key.
Enter or modify your data and apply the necessary formatting options to the sheet that's displayed

View all Excel hints and tips


Server loaded in 0.08 secs.