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

excel vba courses london - how do i group

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel vba courses london - How do I group and outline my spreadsheet?

excel vba courses london - How do I group and outline my spreadsheet?

ResolvedVersion Standard

Caroline has attended:
Excel Intermediate course

How do I group and outline my spreadsheet?

See above

RE: How do I group and outline my spreadsheet?

Hi Caroline,

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:

Recovering Unsaved Work in Excel 2010

Ever closed your Excel workbook in a hurry without saving your work beforehand? Here's how to get it back.

Choose File then Info, click Manage Versions and then Recover Unsaved Workbooks which will automatically find the spreadsheets that haven't been saved.

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