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

microsoft-excel-courses - grouping

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

microsoft-excel-courses - Grouping

ResolvedVersion 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:

Calculate age or service

The DATEDIF() function in Excel calculates the number of days, months, or years between two dates. So, this function makes it easy to calculate a person's age. To try this tip:

In a blank worksheet, type the birth date in cell A1, using slashes to separate day, month, and year.
In cell A2, type =DATEDIF(A1,TODAY(),"y") and press ENTER.

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