Show Change As A Delta Symbol in Excel

changing "change" to deltas in Excel


When I’m working with tables or charts, I like to make labels as short as possible. So when I’m showing a change in a metric over time, like percent difference, I’ll use the delta symbol (Δ) instead of writing out “change” or “difference.”

To do this, just type a capital D (I think of d for delta), select it, then change the font to Symbol. Voila! You have a delta character.

Note: If you’re using a formatted table — and you should almost always format your data as a table — the delta may mess up your heading formatting. In the example below, it made the white font black. If it does, nbd … Just reformat it to match.

I use this when I’m formatting the Search Queries report in Google Webmaster Tools (under Traffic). Here’s what it looks like before and after:

showing delta in excel

Click for larger image.

Photo by lbj79us.





Powered by WishList Member - Membership Software