How to Use Increase Decrease Arrows in Excel - Excel Tips and Tricks

Learn how to use increase and decrease arrows to show trend in Excel.

In this video, we utilize up and down arrows (increase/decrease) to demonstrate how data sets vary based on the specified percentages. Positive numbers display with an up arrow, whereas negative numbers display with a down arrow.

Here are the steps.
1) Select cell
2) Ctrl + 1
3) Number tab
4) Custom
5) Enter following in Type.
[green]▲0%;[red]▼0%;
Scroll 13 down in Character Map Window
6) OK
7) Apply to all cells

I do not own the "Drawn Number Circle Png". You can find that from the link below.

#microsoft #excel #exceltips #tips #exceltricks #tricksandtips

[persimmonswillis]

when i double clicked on the first cell, the rest of the cells below it became the same amount. It copied and duplicated the data of the first cell. Tq