Excel.Tips.Net Welcome toExcel.Tips.Net

Helpful Links

Tips.Net Home
ExcelTips Home
Ask an Excel Question
Make a Comment

Tips.Net Store

ExcelTips FAQ
ExcelTips Premium

Learn Access Now
Free Printable Forms

Beauty Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Legal Tips
Money Tips
Organizing Tips
Pest Tips
Pet Tips
Wedding Tips
Word2007 Tips
WordTips

Advertise on the
ExcelTips Site

Newest Tips

Removing Borders

Converting to Octal

Filtering Columns for Unique Values

Printing Multiple Worksheets on a Single Page

Changing the Default Font

Creating a Drawing Object

Determining a Value of a Cell

 

Grouping and Ungrouping Objects

Summary: Graphics can be placed easily into a worksheet. You can combine graphics together—group them—so they are treated as a single unit. This tip explains how. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, Excel 2003, and Excel 2007.)

Excel provides a feature found in many graphics programs--the ability to group graphics objects. For instance, you can spend a great deal of time positioning graphics objects in just the right position in order to achieve a desired effect. It is not unusual to create compound objects that are comprised of dozens of smaller objects.

Rather than risk getting the objects out of order or having their positions changed, you can group them so that they are treated as a single object. This is done by selecting all the objects you want grouped together (hold down the Shift key as you select each object).

Finally, choose the Group option which is available from the menu visible when you click on Draw on the Drawing toolbar (or, if you are using Excel 2007, right-click one of the images in the group and choose Group | Group). Notice that the individual handles for each object disappear, and instead, handles appear around a rectangle that encompasses all the objects in the group.

If you later want to ungroup the objects, simply choose the object you want to ungroup and choose Ungroup from the Draw menu or right-click the group and choose Group | Ungroup.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2466) applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Don't Go in Debt for Christmas! Tired of trying to keep up with the Joneses for Christmas? Want to enjoy the season rather than dread the aftermath? Learn how you can avoid the financial traps that spring up every Christmas.
 
Check out Top Fifteen Tips for Financing Christmas today!