How to Insert a Pyramid in Microsoft Excel 2010

While Microsoft Excel is typically thought of as a way to save, sort, and manipulate data, it has some additional tools that let you add objects and media to your spreadsheets.

You might have already added a picture or a text box in the past, but there are also tools to add shapes, even some less traditional ones that you might put in other documents.

Our tutorial will show you how to insert a pyramid in Microsoft Excel 2010 and then add data to and format that pyramid.

How to Add a Pyramid to a Spreadsheet in Excel

  1. Open your spreadsheet.
  2. Select the Insert tab.
  3. Click the SmartArt button.
  4. Choose the Pyramid tab, then select a pyramid style.
  5. Add information to the pyramid.
  6. Use the SmartArt Tools tabs to customize the look of the pyramid.

Our guide continues below with additional information on how to insert a pyramid in Microsoft Excel 2010, including pictures of these steps.

Many people think of Microsoft Excel as a program that is mainly for storing and sorting data in a spreadsheet.

However, it actually has some pretty exciting capabilities that can make it a good choice for creating visually appealing documents as well.

Among these features is the ability to create and insert SmartArt, which are graphical elements that you can customize with your own text. One of these SmartArt options is a pyramid that you can configure in a number of different ways.

This article will show you how to insert a SmartArt pyramid in Microsoft Excel 2010, as well as point out the menus where you can select the formatting and content options for the object.

If you use Google Slides to create presentations, then click here to find out more about adding bullet points to your slides.

How to Create a SmartArt Pyramid in Excel 2010 (Guide with Pictures)

The biggest appeal of the Excel 2010 SmartArt pyramid is simply how it looks.

The pyramid itself is very striking and will certainly draw the eye of anyone that is viewing your spreadsheet.

It also provides you with a place to quickly summarize your data without having to modify any of the original data in your spreadsheet.

Continue reading below to learn more about inserting a pyramid in Excel 2010.

Step 1: Launch Microsoft Excel 2010.

Step 2: Click the Insert tab at the top of the window.

excel 2010 insert tab

Step 3: Click the SmartArt button in the Illustrations section of the ribbon at the top of the window.

This is going to open a new window titled Choose a SmartArt Graphic.

insert smartart excel 2010

Step 4: Click the Pyramid option in the column at the left side of the window, choose your preferred pyramid style from the center column, then click the OK button at the bottom of the window.

how to insert a smartart pyramid in excel 2010

Step 5: Click a bullet point in the column to the left of the pyramid, then type the information that you want to appear in that pyramid level.

Note that you can delete pyramid levels by pressing the Backspace key on your keyboard, and you can add pyramid levels by pressing the Enter key on your keyboard.

enter excel pyramid info

Step 6: Once all of the information that will appear on the pyramid has been added, you can format the appearance by making changes on the SmartArt Tools Design and Format tabs at the top of the window.

format excel 2010 pyramid

Clicking either of these tabs will generate a new horizontal menu in the ribbon at the top of the window. Use the settings on these menus to adjust the appearance and structure of the pyramid.

Now that you know how to insert a pyramid in Microsoft Excel 2010 you can use this feature whenever your spreadsheet would benefit from that type of object.

Join Our Free Newsletter

Featured guides and deals

You may opt out at any time. Read our Privacy Policy

Leave a Comment