Grouping

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

Resolved · Low Priority · Version 2003

Grouping

Lindsay has attended:
Excel Intermediate course

by - delegate Lindsay [1 post] (2008 Jun 25 Wed, 16:57) Reply

Please can you remind me of grouping large workbooks

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2009 Jan 9 Fri	Bloomsbury	1	book now	£240	£245
2007	2009 Jan 14 Wed	Bloomsbury	5	book now	£235	£245
2002/XP	2009 Jan 14 Wed	Tooting	0	FULL
2003	2009 Jan 16 Fri	Southwark	0	FULL
2007	2009 Jan 21 Wed	Bloomsbury	3	book now	£240	£245
2003	2009 Jan 21 Wed	Southwark	2	book now	£235	£240
Full Schedule: See all 114 Excel Advanced course dates. Bookings currently available until 31st March 2010.

RE: grouping

by - trainer Pete platinum contributer [868 posts] (2008 Jul 14 Mon, 09:16) Edited on 2008 Jul 14 Mon, 09:17 Reply

Hi Lindsay,

Thank you for your post and welcome to the forum;

To give you that reminder, you can group large or even small worksheets by clicking on the tab at the bottom of the workbook, then using either the CTRL key (where sheets are not touching each other ie 1 3 and 7) or the SHIFT key where they are (sheets 1,2,3,4) click others to select;

So to recap:click on the first sheet and using as above click on the next sheet or in the case of SHIFT on the last sheet to be grouped. You will now notice that the sheet tabs are all showing 'selected' and can be worked on as a group.

I hope that has jogged the memory, regards Pete

· Features of Microsoft Excel that assist in Analysis of Financial Data
· Excel Macros for the Non-Programmer
· Advanced level training: Microsoft Excel and the Web
· How to Create Better Excel Spreadsheets: Part Four
· Database Tips from an Excel Training Course

Please browse our web site to find out more about
excel 2003 visual basic intermediate course and other Microsoft training courses.

Excel tip:

Hiding a worksheet in Excel

Want to circulate an Excel workbook file but keep certain worksheets hidden from your colleagues' view?

You can do so by bringing up the sheet you wish to hide on your screen; then going to Format - Sheet - Hide.

It will not be immediately obvious that a sheet is hidden from view unless perhaps the sheet are still labelled Sheet 1, Sheet 2 etc.

To display the sheet again, you can go to Format - Sheet - Unhide on any of the other sheets in the workbook. A dialogue box will appear, allowing you to select the hidden sheet/s. Click OK to make the sheet/s reappear again.

View all Excel hints and tips

Rate this page: