MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel 2020: Merge Shapes


December 03, 2020 - 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


This article is an excerpt from MrExcel 2020 - Seeing Excel Clearly.


Bill Jelen is the author / co-author of
MrExcel 2020 - Seeing Excel Clearly

This is a 4th edition of MrExcel LX. Updates for 2020 include: Ask a question about your data, XLOOKUP, Power Query's Data Profiling tools, How Geography Data Types decide which Madison, A SEQUENCE example for descending 52 weeks, Exchange Rates support in Stock Data Types, How to collapse the Search box, How to leave effective feedback for Microsoft, How to post your worksheet to the MrExcel Board using XL2BB.