microsoft-excel-courses - grouping

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft-excel-courses - Grouping

microsoft-excel-courses - Grouping

resolvedResolved · Low Priority · Version Standard

Margie has attended:
Excel Introduction course
PowerPoint Introduction course
Upgrade to Office 2007 course

Grouping

How can i group six worsheets together?

RE: Grouping

Hi Margie

Thanks for your question.

You can group worksheets together by selecting the tabs for the worksheets to be grouped.

If the sheets are next to each other in the Excel file, you can click on the first sheet tab, hold down Shift and click on the sixth sheet tab. This will select all the sheets between the first and sixth sheet.

If the sheets are not next to each other in the Excel file, then click on the first sheet tab, hold down Ctrl and keeping hold Ctrl down while you click on the sheet tabs of the other sheets you wish to include in the group.

I hope this helps.
Amanda


 

Excel tip:

Rotating Text in an Excel 2010 Worksheet

Maybe you want to draw attention to certain text or you just simply want to make your worksheet look more exciting!

One of the things you might consider is, rotating the text in a particular cell or set of cells.

1) Select a cell you would like to rotate
2) Click the ''Home'' tab in the Ribbon
3) Click ''orientation'' in the ''Alignment'' section
4) A pop up menu will appear with a few choices, if you want to decide yourself how many degrees to rotate the text, then click ''Format Cell Alignment.''

View all Excel hints and tips


Server loaded in 0.09 secs.