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 2016, Regular square in Office 2016, Pentagon in Office 2016, Hexagon in Office 2016, 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 2016

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 2016

   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 2016

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.

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