98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Grouping
Grouping
Resolved · Low Priority · Version 2003
Lindsay has attended:
Excel Intermediate course
Grouping
Please can you remind me of grouping large workbooks
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
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Shortcut fill a cell with contents from adjacent cellsUse 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! |