How to Add Up and Down Arrows in Excel (4 Easy Ways)

You might want to add up and down arrows in Excel so that you could easily understand the increase and decrease in the price of your business commodities and stock price. We can easily take a decision from the up and down arrows from the price of the business commodities and stock. Adding up and down arrows is an easy task. In this article, we’ll learn four quick and suitable ways to add up and down arrows in Excel.


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


4 Suitable Ways to Add Up and Down Arrows in Excel

Let’s say, we have a dataset that contains information about several stock companies. The Name of the stock companies, yesterday’s closing price(YCP), Present Price, and the percentage of change are given in Columns B, C, D, and E respectively. We might add up and down arrows in Excel using the Conditional Formatting, IF Function, Custom command, and Font command. Here’s an overview of the dataset for today’s task.

add up and down arrows in excel


1. Use Conditional Formatting to Add Up and Down Arrows in Excel

In this section, we will apply Conditional Formatting to add up and down arrows in Excel. From our dataset, we can easily add up and down arrows. Let’s follow the instructions below to add up and down arrows!

Steps:

  • First, select cells E5 to After that, from your Home ribbon, go to,

Home → Styles → Conditional Formatting → Icon Sets → Directional( Select any Set)

Use Conditional Formatting to Add Up and Down Arrows in Excel

  • As a result, you will be able to add up and down arrows which have been given in the below screenshot.


2. Apply IF Function to Add Up and Down Arrows in Excel

Now, we will apply the IF function to add up and down arrows in Excel. To do that, firstly, you insert up and down arrows from the Symbol option. Let’s follow the instructions below to add up and down arrows using the IF function!

Step 1:

  • First, select cell C16.

Apply IF Function to Add Up and Down Arrows in Excel

  • Hence, from your Insert ribbon, go to,

Insert → Symbols → Symbol

  • As a result, a Symbol dialog box will appear in front of you. From the Symbol dialog box, firstly, select the Symbols Secondly, select Arial Black from the Font drop-down list.
  • Further, select Arrows from the Subset drop-down list.
  • At last, press Insert.

Apply IF Function to Add Up and Down Arrows in Excel

  • After that, you will be able to insert the up arrows.

  • Similarly, insert the down arrow.

Apply IF Function to Add Up and Down Arrows in Excel

Step 2:

  • Now, select cell F5, and write down the IF function in that cell. The IF function is,
=IF(E5>0,C$16,D$16)

  • Hence, press Enter on your keyboard.
  • As a result, you will be able to get the return of the IF function.
  • The return is up arrow().

Apply IF Function to Add Up and Down Arrows in Excel

  • Further, AutoFill the IF function to the rest of the cells in column F which has been given in the screenshot.


3. Perform Custom Command to Add Up and Down Arrows in Excel

Further, we will perform the Custom command to add up and down arrows in Excel. We can easily do that from our dataset. Let’s follow the instructions below to add up and down arrows!

Steps:

  • First, select cells E5 to Hence, press Ctrl + 1 on your keyboard.

Perform Custom Command to Add Up and Down Arrows in Excel

  • As a result, a Format Cells dialog box will appear in front of you. From the Format Cells dialog box, firstly, select the Number Secondly, select Custom from the Category drop-down list.
  • Further, type [Green]0.00%↑;[Red]0.00%↓ in the Type box.
  • At last, press OK.

  • After completing the above process, you will be able to add up and down arrows which have been given in the below screenshot.

Perform Custom Command to Add Up and Down Arrows in Excel


4. Change Font Style to Add Up and Down Arrows in Excel

Last but not the least, we will add up and down arrows changing the Font. From our dataset, we can easily do that. This is a time-saving task also. Let’s follow the instructions below to add up and down arrows!

Steps:

  • First, select cells B5 and B6 which contain the Hash(#) and Dollar($) sign.

Change Font Style to Add Up and Down Arrows in Excel

  • After that, from your Home ribbon, go to,

Home → Font

  • Hence, select the Wingdings 3 to convert the Hash(#) and Dollar($) sign into up and down arrows respectively.

  • Finally, you will get the up and down arrows that have been given in the below screenshot.

Change Font Style to Add Up and Down Arrows in Excel


Things to Remember

👉 #N/A! error arises when the formula or a function in the formula fails to find the referenced data.

👉 #DIV/0! error happens when a value is divided by zero(0) or the cell reference is blank.


Conclusion

I hope all of the suitable steps mentioned above to add up and down arrows will now provoke you to apply them in your Excel spreadsheets with more productivity. You are most welcome to feel free to comment if you have any questions or queries.

Md. Abdur Rahim Rasel

Md. Abdur Rahim Rasel

Hi! I'm Md. Abdur Rahim Rasel. Welcome to my Profile. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to this. I have completed my graduation in Naval Architecture and Marine Engineering(NAME) from Bangladesh University of Engineering and Technology(BUET). I have a passion for learning new things with my knowledge through perseverance and hard work.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo