Create a hierarchy in Excel: 6 steps (with pictures)

Table of contents:

Create a hierarchy in Excel: 6 steps (with pictures)
Create a hierarchy in Excel: 6 steps (with pictures)

Video: Create a hierarchy in Excel: 6 steps (with pictures)

Video: Create a hierarchy in Excel: 6 steps (with pictures)
Video: Excel Tip Compress Picture Sizes In Excel 2023, December
Anonim

This wikiHow teaches you how to use Microsoft's SmartArt function in Excel to insert a representation of the hierarchy.

method

Create Hierarchy in Excel Step 1
Create Hierarchy in Excel Step 1

Step 1. Open a new Microsoft Excel spreadsheet

You can insert a representation of the hierarchy in every Excel workbook, regardless of its content.

Create Hierarchy in Excel Step 2
Create Hierarchy in Excel Step 2

Step 2. Click the Insert tab

You can find this button at the top of the screen in the navigation bar next to other options like begin, Formulas and Check. This will open the insert toolbar at the top of the workbook.

Create Hierarchy in Excel Step 3
Create Hierarchy in Excel Step 3

Step 3. Click the SmartArt button

This will open a menu with different types of SmartArt objects that you can insert into your Excel workbook.

Create Hierarchy in Excel Step 4
Create Hierarchy in Excel Step 4

Step 4. Hover your mouse over hierarchy

This will show you different types of representations of the hierarchy that you can use.

Create Hierarchy in Excel Step 5
Create Hierarchy in Excel Step 5

Step 5. Choose a representation of the hierarchy

Click on the representation you want to add. This creates a new hierarchy representation and inserts it into your workbook.

Create Hierarchy in Excel Step 6
Create Hierarchy in Excel Step 6

Step 6. Fill in the hierarchy branches

Click on a field and use your keyboard to type in the content of your hierarchy display.

Recommended:

Create a Youtube Video with Pictures: 14 Steps (with Pictures)

Create a Youtube Video with Pictures: 14 Steps (with Pictures)

You can find almost every piece of music in the world on YouTube. Most of them are uploaded by fans all over the world and provided with simple pictures as background music. Assembling the video is easy, all you need is pictures, the music file, and simple video editing software.

Create Tables in Excel: 14 Steps (with Pictures)

Create Tables in Excel: 14 Steps (with Pictures)

A spreadsheet is a great tool for adding the sum of a series of elements. Using the example of a simple expense report, this article explains how to create a simple spreadsheet in Microsoft Excel. method Step 1. Open Excel Step 2.

How to Create a Bar Chart in Excel: 10 Steps (with Pictures)

How to Create a Bar Chart in Excel: 10 Steps (with Pictures)

This wikiHow teaches you how to use a bar chart to create a visual representation of your data in Microsoft Excel. method Part 1 of 2: insert data Step 1. Open Microsoft Excel The icon shows a white "X" on a green background (PC) or a green X (Mac).

Create a Chart in Excel: 12 Steps (with Pictures)

Create a Chart in Excel: 12 Steps (with Pictures)

This wikiHow teaches you how to create a chart or graph in Microsoft Excel. You can do this on both a Windows PC and a Mac. method Step 1. Open Microsoft Excel The app's icon resembles a green box with a white "X" in it.

To Create a Custom Function in Microsoft Excel: 13 Steps (with Pictures)

To Create a Custom Function in Microsoft Excel: 13 Steps (with Pictures)

While Excel has a lot, probably hundreds, of built-in functions like SUM, VLOOKUP, LEFT, etc., you will often find that you need a function that doesn't exist when you use Excel for more complicated tasks. Don't worry, you are not lost, you just have to create a function yourself.