

I’ve seen many examples in which you want to work with flag icons in Excel. That might be when you compare countries, markets, sales per region and so on. Instead of just writing long country names – or shorter but maybe not so intuitive abbreviations – you could insert flag icons. In this article, I’ll describe ways to insert country flags into Excel cells and charts.
Contents
Due to a lot of limitations, using images or pictures is usually the best solution for working with flag icons in Excel. However, if you only work on Mac systems, you could also use emojis. For Windows users there is one alternative: The new FIELDVALUE function. But it works only in cells (not charts) and doesn’t come with many formatting options. Here is the summary:
Insert flag into: | Windows | Mac |
---|---|---|
Table / Cell | FIELDVALUE / Data Types (click here to jump to section) | Emoji (click here to jump to section) |
Chart | Image | Emoji |
The first method works universally in most versions of Excel. And as of now, it’s the only one with detailed formatting options. But, admittedly, it’s a pain. It works like this:
That’s it. Sounds simple, right? It is – until you start the dragging and moving around.
Maybe in this context a tip: When selecting the pictures, Excel provides alignment and sizing features as highlighted in the screenshot below:
This is one of the rare cases – when it comes to Microsoft Office – that Mac users have an advantage. They can insert any emoji the system supports. And it seems that Apple is using the usual emoji set (Microsoft Windows only seems to support a selection, not sure why…).
That means, you can insert the country flags by clicking on “Edit” and then on “Emoji & Symbols” from the menu bar.
If you open the same file on a Windows computer, it looks like this.
Microsoft seems to be working on the FIELDVALUE function which is getting increasingly powerful. It pulls data from (external) sources. One of the first functions is country data. Besides inserting only text or numeric data, it can also insert flag icons.
Here is how to do it:
Excel now adds the small “Geography” symbol in your country cells. The last step is to insert the flags. Just click on the small icon “Insert Data” and select “Image”.
Please note: this feature is only available on newer versions of Microsoft Excel. For more information about the FIELDVALUE function, please refer to this article.
The result might look similar to this:
Please feel free to download all the examples above in one Excel workbook. Just click here.
Was the information helpful in this article?
Image credit of round icon: Icons made by Roundicons from www.flaticon.com
'Professor Excel Tools': Add more than 60 amazing features to Excel!
Professor's Error Helper for Excel: Solve any error in Excel.
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
Subscribe to our popular Excel newsletter! You get all this:
Your welcome gift: Our big 45 pages keyboard shortcuts package.
Subscribe now! In case the sign-up form above doesn't work, please use this page. Sorry for the inconvenience.
Please use this download link to download the Currency Converter Excel add-in!
Please use this download link to download the comment extraction example: http://bit.ly/Extract_Comment_Example