Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

I can change the Height and Width of an object by entering values in the controls in the Format / Size group. How do I enter values for the Top and Left properties?

April 26, 2017controls entering format group height object size values

0

Posted

I can change the Height and Width of an object by entering values in the controls in the Format / Size group. How do I enter values for the Top and Left properties?

1 Answer

0

Posted

You don’t. You can, however specify the Top and Left properties by using VBA. Q: When I right-click a Shape, I see an option to “Set as Default Shape.” This command seems to have no effect. A: When you choose that command, Excel uses the *formatting* that you’ve applied to the shape as the default (fill, outline, effects).