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

microsoft excel course - how do group and

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel course - How do I group and outline my spreadsheet

microsoft excel course - How do I group and outline my spreadsheet

ResolvedVersion Standard

Sarah has attended:
Excel Introduction course
Excel Intermediate course
Excel Advanced course
Access Introduction course

How do I group and outline my spreadsheet

See above

RE: how do i group and outline my spreadsheet

Hi Sarah,

Thanks for the question.

Grouping and outllining your work means you can show or hide various sections of rows or columns alike. The Group and outline option can be found under the Data menu. I suggest you highlight the section (rows or columns) you want to hide first then go into Data>group and Outline and then you can manually group the data, alternatively leave it to Excel and go for the Auto Outline.

Hope that helps

Tracy

Excel tip:

Display developer tab - Excel 2010

a. In Excel, click on the File tab
b. Select Options from left hand side
c. Choose the Customize Ribbon section
d. Click the box next to Developer in the list of tabs on the right hand side of the dialog box. When ticked the Developer tab will be visible.
e. Click OK to apply your changes

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