How do I keep the shapes inside excel text box

Question

Good Morning,

How do I keep the shapes inside excel text box that moves together with text box?

thanks,

Answer 1

Hi Therence Valdez,

Thanks for your valuable feedback and sharing updates with us and I really appreciate your effort and your precious time doing. 

And I appreciate your kind words.

It sounds like you are looking to create a sort of "container" for shapes that you can move as a group, but still allow for individual shapes to be copied and used elsewhere independently.

You can achieve this using grouping and potentially using a shape as a container instead of a text box:

Create a Larger Container Shape:

Go to the Insert tab, click Shapes, and choose a rectangle shape that can act as a container. Resize this shape to fit all the smaller shapes you want to include. Insert the smaller shapes inside the larger shape.

Group the Shapes:

Click the larger shape to select it. Hold down the Ctrl key and click each of the smaller shapes you want to include. With all shapes selected choose Group >Group. Now, when you click and drag the larger shape, all the smaller shapes will move with it automatically.

For Copying Individual Shapes:

Click to select the grouped object.

Click again on the specific smaller shape inside the group.

Copy it using Ctrl+C and then paste it where needed in your report using Ctrl+V.

By grouping shapes in this way, you can manage a collection of objects.

Meanwhile, in this case, if you think my provided idea is helpful and you can understand my explanation and correct direction on this whole scenario, could you please use the feedback tool to send us feedback? (photo below).

The reason why I am asking you because other users will also be looking for information in this community. From your valuable votes, other users can easily find that topic and find the right path to post their query and search for useful information faster.

Your feedback really means a lot to the dedicated members of our community.

If there are any issues with Office apps in the future, feel free to post to this community again.

We will be there to help you.

Have a great day and stay safe 😊

Sincerely

Waqas Muhammad

Answer 2

Hello Waqas,

Thanks for your response , control click works.

Here is what I want to so

1. I want to collect shapes and put it inside the bigger box
2. When i move the bigger box all shapes go with it without having to control click each one
3. When im ready to use 1 shape for example, I can simply copy it and paste to my report

I have very little knowledge on this. Maybe you other ways to do this aside from textbox?

Thanks

Answer 3

Dear respected  Therence Valdez,

Good day! Thank you for posting to Microsoft Community. We are happy to help you.

As per your description, you may use "Group" then together.

1.Select both shapes (usually a Control+Click on each works)

2.Now the two selected shapes>Choose Group from the Shape Format ribbon.

3.The two shapes can now be moved around as one.

If there is any misunderstanding, I apologize and please feel free to post back to us with more detailed information for better understanding and guiding you further.

We appreciate your understanding that sometimes the initial suggestions may not resolve the problem very soon. However, we can work together to narrow down and resolve the situation. So, please kindly provide more information below to let us work further.

Please understand that our initial reply may not always immediately resolve the issue. However, with your help and more detailed information, we can work together to find a solution.

I'm sorry and I apologize for that.

Appreciate your patience and understanding and thank you for your time and cooperation.

Sincerely,

Waqas Muhammad