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.

Thank you for visiting OfficeToolTips

We are glad to help you in your work. However, you are using ad blocker and our efforts will not be rewarded.

Please consider disabling ad blocker before continuing the reading.