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.





Leave a Reply

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>