In this video we're going to look at 15 tips and tricks for working with shapes in Microsoft Excel. Learn some easy tips for getting the most out of Excel shapes.
Table of Contents
1. Add text inside any shape 0:18
2. Change shapes 1:12
3. Lock a shape’s aspect ratio 1:37
4. Add multiple columns for text inside shapes 2:22
5. Lock the drawing mode for inserting multiple shapes 3:09
6. Select and edit all shapes in the sheet 3:58
7. Use dynamic content for text inside a shape 4:46
8. Connect shapes with connectors 5:30
9. Settings for moving and resizing shapes with cells 6:10
10. Easily align shapes with snap shapes to grid 7:12
11. Removing shapes from printing 8:29
12. Lock shapes to protect them from editing 9:21
13. Set default shape format and settings 11:38
14. Hide shapes with the selection pane window 12:25
15. Wrap text, overflow text and resize a shape to fit text 13:05
Check out my full courses and ebooks here
https://www.howtoexcel.org/courses/
DOWNLOAD the example workbook here
https://www.howtoexcel.org/downloads/
SUBSCRIBE & get my 3 FREE eBooks
https://www.howtoexcel.org/newsletter/
CONNECT with me on social
Facebook: / howtoexcelblog
Twitter: / howtoexcelblog
LinkedIn: / johnmacdougall
Thanks for all your support!