microsoft-excel-courses - Grouping

The UK's most regular instructor-led training courses.
Training information: microsoft-excel-courses · Excel training courses · Microsoft Excel Training UK
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Grouping

Margie has attended:
Excel Introduction course
Powerpoint Introduction course

by - delegate Margie [1 post] (2007 Mar 13 Tue, 14:28) Reply

How can i group six worsheets together?

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Sep 8 Mon + 9 Tue	Bayswater	2	book now	£495	£495
2003	2008 Sep 18 Thu + 19 Fri	Bloomsbury	1	book now	£495	£495
2003	2008 Sep 25 Thu + 26 Fri	Southwark	3	book now	£475	£495
2003	2008 Oct 6 Mon + 7 Tue	Bayswater	4	book now	£475	£485
2007	2008 Oct 13 Mon + 14 Tue	Bayswater	3	book now	£475	£495
2003	2008 Oct 23 Thu + 24 Fri	Southwark	4	book now	£475	£485
Full Schedule: See all 44 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Grouping

by - trainer Amanda platinum contributer [968 posts] (2007 Mar 13 Tue, 15:42) Reply

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