MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel 2019: Merge Shapes


November 27, 2019 - by Bill Jelen

Excel Merge Shapes. Photo Credit: Simone Hutsch at Unsplash.com

Here‘s a brief plug for PowerPoint: If you need to create a shape in Excel that is a combination of other shapes, create the shapes in PowerPoint. 


Select all the shapes you want to include. On the Drawing Tools Format tab, choose Merge Shapes. You can then select Union, Combine, Fragment, Intersect, or Subtract to combine the shapes. (The Subtract feature lets you cut a hole in a shape.) Then copy that shape and paste to Excel (or Word).

Thanks to Sam Radakovitz and Echo Swinford for contributing this tip.

Title Photo: Simone Hutsch at Unsplash.com


Bill Jelen is the author / co-author of
Excel Insights – A Microsoft MVP Guide to the Best Parts of Excel

There are fewer than 100 Excel MVPs worldwide. 24 of them have contributed to this book. Written, edited, reviewed and printed by Excel MVPs, this is practical Excel passion undiluted, with each MVP highlighting some of their favorite topics.