Forum Discussion

Kacolulo's avatar
Kacolulo
Copper Contributor
Jul 02, 2024

How to group two shapes in Excel?

Hello,

I would like to group two shapes in my Excel spreadsheet. However, I can't do it at all. Many tutorials indicate that you must first select a shape and then press and hold the Ctrl key and select the second shape. But it doesn't work. I tried everything; with the SHIFT, Shift, Alt, Fn key. Nothing does it.

I work on iPad Pro but I also tried on my SAMSUM RC720 PC. but without success.

What should I do, is there something to set up?

Could you help me please.

  • Kacolulo 

    Broadly, the instructions you have found are correct.   Ctrl / left Click should select the shapes.

    Something else that might give a little more control is Home / Find & Select / Selection pane which allows you to select multiple shapes by ctrl-clicking the names or Home / Find & Select / Select Objects that will allow you select objects within a boundary rectangle.

    • Kacolulo's avatar
      Kacolulo
      Copper Contributor

      Thank you for your answer, but unfortunately I can't select the cells in which my two shapes are located.

      I don't understand, because I use Excel which is online and I pay for in order to get all the features. However, when I look at Excel tutorials, there is the (group) function and I don't have it.

      Have a good day

       

      • PeterBartholomew1's avatar
        PeterBartholomew1
        Silver Contributor

        Kacolulo 

        As SergeiBaklan suggests, my comments were specific to desktop versions of Excel in which shapes are layered in front of the grid rather than being part of it.  The same would apply to the Excel tutorials you have studied.

Resources