+ Reply to Thread
Results 1 to 4 of 4

Group Shapes

  1. #1
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Group Shapes

    Is it possible to group shapes together,so if one shape moves they all stay in aligment? I tried
    a lot of different ways with no luck, not sure if its possible so its time to ask a expert.
    Z
    Attached Files Attached Files
    Last edited by zplugger; 04-03-2013 at 11:15 AM.

  2. #2
    Forum Contributor
    Join Date
    09-27-2012
    Location
    Florida
    MS-Off Ver
    Excel XP to 2013
    Posts
    342

    Re: Group Shapes

    Hold down the shift key and left click on each shape, when they are all selected left click and select Group and Group from the menu.
    Tom S.
    ↙ If you find my reply helpful click on the * down there on the left. Yeah that's it, right there, down on the left
    If your question is resolved, mark it SOLVED using the thread tools.

  3. #3
    Valued Forum Contributor
    Join Date
    03-29-2013
    Location
    United Kingdom
    MS-Off Ver
    Office/Excel 2013
    Posts
    1,749

    Re: Group Shapes

    You can save time and do it programmatically with the following code

    Please Login or Register  to view this content.
    Click in cell A1 to select all shapes then select "Group"
    Elegant Simplicity............. Not Always

  4. #4
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Re: Group Shapes

    Thanks Guys, both ways work Great. Goes to show you, if you don't know ask.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1