Take a Guess to Win Windows 10 Pro Key!
previous arrow
next arrow
Slider

How to Insert Data Bars or Directional Icons to Excel Cells

Date:2019-9-30 Author:Cordelia

Excel can not only process data quickly, but also display data in various ways intuitively. For example, you can insert data bars or directional icons to show numerical value of each cell in Excel. And the method is very simple.

How to Insert Data Bars

1. Select the cells you want to add data bars.

How to Insert Data Bars or Directional Icons to Excel Cells

2. Click Conditional Formatting in Home tab. Choose Data Bars in the drop-down list.

How to Insert Data Bars or Directional Icons to Excel Cells

3. Click Data Bars to expand the menu. There are lots of fill styles. You can put the cursor at any of the icons to see the preview.

How to Insert Data Bars or Directional Icons to Excel Cells

4. Click the one you like to apply it to the cells you selected immediately.

How to Insert Data Bars or Directional Icons to Excel Cells

How to Insert Directional Icons

1. Similarly, select the cells you want to add icons and click Conditional Formatting in Home tab.

2. Select Icon Sets in the menu.

How to Insert Data Bars or Directional Icons to Excel Cells

3. There’re several sets of icons under Directional category. Choose the one you prefer.

How to Insert Data Bars or Directional Icons to Excel Cells

4. It will be added to selected cells according to the numerical value.

How to Insert Data Bars or Directional Icons to Excel Cells

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *