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 » Grouping

Grouping

resolvedResolved · Low Priority · Version 2003

Lindsay has attended:
Excel Intermediate course

Grouping

Please can you remind me of grouping large workbooks

Edited on Mon 14 Jul 2008, 09:17

RE: grouping

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


 

Excel tip:

Shortcut fill a cell with contents from adjacent cells

Use Control + D to fill a cell with the data from an adjacent cell. This speeds up data entry and is a cool tip to share!


View all Excel hints and tips


Server loaded in 0.08 secs.