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.

If you have any questions or suggestions, please feel free to ask OfficeToolTips team.