web analytics

HOW TO GROUP IMAGES IN MICROSOFT EXCEL 2013

Microsoft Excel 2013

This article is about grouping images in a Microsoft Excel 2013 worksheet. Usually in Microsoft Excel there are situations that require to group different graphic objects in order to have them act as one in order to be able to move all the objects with one move instead of having it to do it several times in a row.

If you want to group several different objects, just hold the Ctrl button and then click each of the objects that you want to group into one. After you have done this, just click on the Group Objects button located in the Arrange Group on the Format tab under the appropriate tools and after that just click the Group button on its drop-down menu.

1

After you have grouped all the graphic objects you want, whenever you click any part of the newly created object, all the parts will be selected. But, if you need to move or size any of the grouped objects individually, you can ungroup them by pressing right click on any of the objects and then click Ungroup on the objects shortcut menu or by clicking Group and then Ungroup located on the Format tab, below the appropriate tools contextual tabs.

2

The selection task pane will enable you to control if the graphic objects are hidden or displayed for you to view. In order to open the selection task game, just select one of the graphic objects on the Excel worksheet and then just click the format button under the respected tools contextual tab. Then click the selection pane button found in the arrange group of the objects format tab.

3

Now, whenever you open the Selection Task Pane you will be able to temporarily hide any of the graphic objects listed by clicking its eye checkbox.

4

If you want to remove the display of all the charts and graphics that are in the worksheet just click on the Hide All Button located at the top task name.

5

If you click the empty eye checkbox you will be able to read the display ahead in graphic object and simply to put the eye icon back into it. To display all the graphic objects after hiding them all, just click on the Show All button located at the top of the Task Pane.

Leave a Reply