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.
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)
- As a result, you will be able to add up and down arrows which have been given in the below screenshot.
Read More: Up and Down Arrows in Excel Using Conditional Formatting
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.
- 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.
- After that, you will be able to insert the up arrows.
- Similarly, insert the down arrow.
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(↑).
- Further, AutoFill the IF function to the rest of the cells in column F which has been given in the screenshot.
Read More: How to Draw Arrows in Excel (3 Simple Ways)
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.
- 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.
Read More: How to Add Trend Arrows in Excel (3 Suitable Ways)
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.
- 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.
Read More: How to Change Cursor from Plus to Arrow in Excel (5 Easy Methods)
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.