How to create an equilateral triangle, a regular square, and other regular polygons in Excel

Excel 2016
For some charts or diagrams, you need to create a regular polygon – equiangular (all angles are equal) or equilateral (all sides have the same length). E.g., equilateral triangle, regular square, etc.
Equilateral triangle in Office 365, Regular square in Office 365, Pentagon in Office 365, Hexagon in Office 365, etc.

When you create a shape in Microsoft Excel, you create a shape with proportions, which depend on the selected area to which Excel fits a shape. For example:

Different shapes in Excel 365

However, there is a way to add any of the available shapes in Microsoft Excel, keeping the correct, regular proportions:

   1.   On the Insert tab, in the Illustrations group, click the Shapes button:

Shapes in Excel 365

   2.   Select a shape you want to add to your spreadsheet.

   3.   Holding Ctrl, click the selected shape. The shape will be added at the current cursor position with regular proportions:

Shapes with regular proportions in Excel 365

Note: All shapes will be added using the default size and style. You always can change the default style for shapes, see Change the default font and style for shapes in Excel.

See also this tip in French: Comment créer un triangle équilatéral, un carré et d'autres polygones réguliers dans Excel.

Please, disable AdBlock and reload the page to continue

Today, 30% of our visitors use Ad-Block to block ads.We understand your pain with ads, but without ads, we won't be able to provide you with free content soon. If you need our content for work or study, please support our efforts and disable AdBlock for our site. As you will see, we have a lot of helpful information to share.