15 Tips and Tricks for Working With Shapes In Microsoft Excel

[@ocsoutstandingconsultingse9927]

OH WOW. For years I have been looking for this kind of capability. It's not been publicized much. This is a fantastic tutorial, well organized, love the topic dividers and the pace and cursor guidance makes it easy to follow. Definitely one of my top tools and tips collection. THANK YOU!

[@helenliu6903]

Good training through computer. I like it.Thanks for the comprehensive discussion. Thumbs up

[@HowToExcelBlog]

Thanks Helen!

[@joyandgroove]

Great video! I learned a lot of cool tips. Thank you for sharing.

[@wayneedmondson1065]

Hi John.. this was great.. showed me about 10 things I didn't know. Thanks for the comprehensive discussion. Thumbs up!!

[@HowToExcelBlog]

I learnt a couple of them as I was making the video. It was originally going to be 9 or 10 tips. 😁

[@leonardmatheson9367]

Thank you, John. Excellent presentation, with good examples that were simple and conveyed a lot of educational information.

[@KiranKumar-dj5pw]

thats the great service you are doing🖖💫💫

[@gomahetti1226]

Very helpful 👍 thank you

[@satishdeshmukh1023]

Very well described!

[@HowToExcelBlog]

Thanks!

[@brit5x]

This video is super informative!!!!!!!!! Subscribed!

[@HowToExcelBlog]

Good to hear 🙂

[@anderbonassoli]

Thank you!

[@abkorpel4647]

Thanks so much, you help me a lot

[@kjohal9583]

Very Good Video - Thanks

[@jotaefearango]

Nice. Thanks.

[@HowToExcelBlog]

Glad you liked it Juan

[@stefanogattoCH]

thank you for this instructive video! Can we define yellow Tips for shapes?

[@HowToExcelBlog]

You'll have to expend on what you mean by yellow tips.

[@stefanogattoCH]

@@HowToExcelBlog I mean that when the user hovers over the shape, then a yellow box appears, to explain something related to that shape. It's like a tooltip, but for a shape, not for a tool.

[@HowToExcelBlog]

Ah, not that I know of.

[@hayderxyz0]

thank you very much

[@gillesfournier9457]

Thank, well explain. I will sppreciate being able to modify shape size by modifying cell value without the use of VBA. We could refer shape text to a cell, so why Excel does not provide this possibility to refer to a cell for shape size ?

[@moonbee03]

Thank you for this. I've learned some new tricks. I was wondering if you can help me. I made a chart with data in Excel, and then I overlayed a rectangle with two colors, which I set to high transparency (mostly 90%, it also has some slight gradient to it). But. I am now trying to "Send it back" to keep the data on my chart looking crisp... I have tried almost everything and looked at the settings as well... and it just won't go back! I also need it to be in the background because I often need to update the data, but I am having to move the overlay shape out of the way and back on top... which still renders the data slightly fuzzy. Do you by any chance know how I can fix this? Thanks!

[@LauraGonzalez-jo8wh]

Hi John, very interesting video. I have a question How you can add a hyperlink to a shape but use a formula instead of a single cell. I would like to add a hyperlink to a shape that goes to the bottom of a table, this table will have variable numbers of rows.

[@hazemali382]

amazing

[@iarumasnaomas]

This was excellent! Thank you so much!

[@HowToExcelBlog]

Glad you liked it!

[@phamtranhoang251]

Hi, it is great video. And, could you give instruction to move shape by function? Ex: I have function today() to show the date of today (4/5), and I want to assign shape to this function to order shape run to the next day if function today() show the date of tomorrow (4/6) without drag shape by hand. Thanks.

[@allabout1135]

Thanks! Do You know how to save and use default shape after closing the file and opening new?

[@HowToExcelBlog]

I don't think there is a way. You could create a new workbook and set a default shape. Then set that workbook to open when you start Excel so it's always your "blank" workbook.

[@WOS1962]

Thanks a lot. can I insert a table inside shapes?

[@HowToExcelBlog]

You could take a linked image of a table and group it with a shape.

[@WOS1962]

@@HowToExcelBlog you mean a screenshot??

[@HowToExcelBlog]

No, copy and paste as linked picture. Home tab > paste > paste as linked picture 🖼

[@HowToExcelBlog]

It's a live picture.

[@WOS1962]

@@HowToExcelBlog wonderful, The method worked. Thank you very very much again.

[@CherudexGaming]

hello, i wonder if there's a way to do a thing with shapes: i wanted to make a sheet with various small shapes with text and value, and a bigger shape my goal is to have the bigger shape to sum up the value of the the small shapes putted inside the bigger shape

[@swapnilpatil2445]

Hello sir, how do I always keep shape on TOP of some image?? (Here, Image is updated by external program) Thanks

[@marymenas]

HI! thanks for the tutorial. When I double click on the shape to write on it, the shape disappears, and it doesn't show what I am typing until I go to another sheet and comeback. I wasn't having this problem before, I'm using excel 2019 on a mac, everything is updated. I'm going crazy! help!!!

[@HowToExcelBlog]

Best advice I can offer is send a frown to the Excel product team. Is there a small happy face icon somewhere in the top menu?

[@jozd5293]

hi, i want to ask about the shape in excel. i have a problem when i make fishbone diagram with shapes and trying to copy paste to word document but it changes whole position become irregular in document. how to fix it ? thanks 🙏🏼

[@Darioq57]

DO you know of a way to protect shapes and still have them excute the machos attached to them? I can't get them to do that. When I protect the sheet, they will give me an arror on my VBA.

[@praneethsm2901]

Sir whenever I try to fit a shape inside a block it takes from the edges of the block not in the middle

[@Ibrahimcampuskarianwala786]

i need your help

[@arielzabatecuizon5147]

Hi, I inserted too many pictures (shapes) in one cell in excel. Say 100 images in same topleftcell. Now everytime I click (select) the topmost image of it, and then select any cell, the window blinks (the images ) Maybe to quickly show that there are multiple on it,. I find it annoying, how to avoid the blinking? Please help.

[@sscalf31]

interesting but does not answer my question. I need to put a diamond in the center of a cell I need to repeat this. It seems impossible.