• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

  • Courses
  • Pricing
    • Free Courses
    • Power BI Course
    • Excel Power Query Course
    • Power Pivot and DAX Course
    • Excel Dashboard Course
    • Excel PivotTable Course – Quick Start
    • Advanced Excel Formulas Course
    • Excel Expert Advanced Excel Training
    • Excel Tables Course
    • Excel, Word, Outlook
    • Financial Modelling Course
    • Excel PivotTable Course
    • Excel for Customer Service Professionals
    • Excel for Operations Management Course
    • Excel for Decision Making Under Uncertainty Course
    • Excel for Finance Course
    • Excel Analysis ToolPak Course
    • Multi-User Pricing
  • Resources
    • Free Downloads
    • Excel Functions Explained
    • Excel Formulas
    • Excel Add-ins
    • IF Function
      • Excel IF Statement Explained
      • Excel IF AND OR Functions
      • IF Formula Builder
    • Time & Dates in Excel
      • Excel Date & Time
      • Calculating Time in Excel
      • Excel Time Calculation Tricks
      • Excel Date and Time Formatting
    • Excel Keyboard Shortcuts
    • Excel Custom Number Format Guide
    • Pivot Tables Guide
    • VLOOKUP Guide
    • ALT Codes
    • Excel VBA & Macros
    • Excel User Forms
    • VBA String Functions
  • Members
    • Login
    • Password Reset
  • Blog
  • Excel Webinars
  • Excel Forum
    • Register as Forum Member

Excel Icons

You are here: Home / Excel / Excel Icons
Excel Icons
December 29, 2016 by Mynda Treacy

An awesome new feature available in Office 365 are Icons. You’ll find Excel Icons in the Insert tab of the ribbon in the Illustrations group:

insert Excel icons

There’s a gallery of icons available and they’re grouped into categories to make them easily searchable:

gallery of icons

Update 1: You can use ALT Codes to enter 1000's of symbols too.

Download the Workbook

Enter your email address below to download the sample workbook.

By submitting your email address you agree that we can email you our Excel newsletter.
Please enter a valid email address.

Download the Excel Workbook. Note: This is a .xlsx file please ensure your browser doesn't change the file extension on download.

Working with Excel Icons

Simply select the Icons you want to insert by clicking on them which will check the box in the top left of the icon and then click ‘Insert’:

select the icon to insert

This downloads a scalable vector graphics (SVG) file.

Note: you must be connected to the internet for Icons to be available as they are downloaded each time you insert them. The downloaded icons are then stored in your workbook so you can go offline and they will remain intact.

Formatting Icons

Resize the icons using the pull handles which are available when the icon is selected, or adjust the height and width on the Format tab:

resizing Excel icons

Tip: use the corner pull handles to retain the aspect ratio when resizing.

You can format the icon colour via the Graphics Tools: Format contextual tab which is available when the icon is selected:

format the icon colour

You can also add an outline in a different colour:

adding outline to excel icons

You can’t colour separate parts of an icon, however if it has a cut out section then you can insert other shapes behind the icon and colour those shapes:

excel icon colour

Some icons lend themselves to nice layering effects:

excel icon with layer

Tip: use the ‘Bring Forward’ and ‘Send Backward’ tools on the Graphics or Drawing Contextual tabs to arrange the order of the icon and shape:

bring forward

Graphics Effects like shadows, reflections etc. are also available:

graphic effects

Use the Rotate menu to flip or change direction of an Icon:

rotate menu

Uses for Excel Icons

I’ll mostly be using icons for my blog posts, but other ideas that come to mind are:

  • Use them as a button; assign a hyperlink or macro to them (right-click > Assign Macro):

use excel icons as buttons

  • Use them to create info graphics
  • Use them (sparingly) to add visual interest in your Excel workbooks and Dashboards
  • Icons are also available in other Office programs like PowerPoint and Word
Excel Icons

More Excel Posts

tips for working in multiple excel files

Hacks for Working in Multiple Excel Files

Awesome tips for navigating, arranging and working in multiple Excel files. Guaranteed to streamline your workflow and increase productivity.
chatgpt for excel

ChatGPT for Excel

Using ChatGPT for Excel can be hit and miss. Learn the best uses for ChatGPT to make your Excel life easier and what to avoid using it for.
excel templates

Where to Find Free Excel Templates

Where to find free Excel templates and how to create your own Excel templates. Using templates saves time and effort.
Easily Remove Password Protection from Excel Files

Easily Remove Excel Password Protection

How to remove Excel password protection when you’ve forgotten the password. Works for sheets, workbooks and read only files.
Import data from a picture to Excel

Import Data from a Picture to Excel

Import data from a picture to Excel. Works with pictures from a file or the clipboard and loads it to the spreadsheet.
excel online

5 Excel Online Features Better than Desktop

5 Excel Online Features Better than Desktop including searchable data validation, track changes, single line ribbon and more.

10 Common Excel Mistakes to Avoid

10 common Excel mistakes to avoid, including merge cells, external links, formatting entire rows/columns and more.
new Excel features

Cool New Features in Excel for Microsoft 365

Cool New Features in Excel for Microsoft 365 including the navigation pane, smooth scroling, unhide multiple sheets and more.
dynamic dependent data validation

Dynamic Dependent Data Validation

Dynamic Dependent Data Validation with dynamic array formulas like FILTER make it quick and easy to set up.
QAT

Excel Quick Access Toolbar

The Excel Quick Access Toolbar is not only a handy for your mouse, but it also enables some super easy keyboard shortcuts.


Category: Excel
Previous Post:Excel Charts for Surveys
Next Post:Toggle Excel Conditional Formatting On and OffToggle Conditional Formatting on/off

Reader Interactions

Comments

  1. Gael

    February 28, 2018 at 2:06 am

    I have upgraded my Excel to version 16.10 but still can’t see the icons in the Illustrations group. Are you in a business version as opposed to the Home version. How do I find these? Many thanks for your help.

    Reply
    • Mynda Treacy

      February 28, 2018 at 8:49 am

      Hi Gael,

      Do you have an Office 365 licence or perpetual licence? Icons are only available to Office 365 users. If you are not an Office 365 subscriber then you won’t get the Icons gallery.

      Mynda

      Reply
  2. Steve Craig

    February 9, 2017 at 7:53 pm

    Hi Mynda

    Sorry to go on about this subject, but we have the latest version of Office 365 pro plus along with office 2016 pro and it doesn’t appear in any versions.

    We have been in contact with Microsoft support and the person we spoke to doesn’t have it in their copy either. Is there any special site you have to go to, to find these updates??

    I see that this would be of great benefit to my organisation and would like to see where this can be retrieved from

    Steve

    Reply
    • Mynda Treacy

      February 9, 2017 at 8:21 pm

      Hi Steve,

      I replied to 3 people already in the comments with this same answer; if you have Office 365 then it may be that you are on the Deferred update channel which hasn’t received them yet. This link has information about the build and release dates and documents what features were included and when: https://technet.microsoft.com/en-us/office/mt465751.aspx?f=255&MSPPError=-2147217396

      You’ll notice the deferred channel hasn’t had any updates, other than security, since last year.

      Hope that helps you figure out why you’re not seeing the updates.

      Kind regards,

      Mynda

      Reply
  3. Dan Hill

    January 3, 2017 at 1:56 am

    We have both Office 2016 Professional and Office 365. This option does not appear to be available in either of the two packages.

    Reply
    • Mynda Treacy

      January 3, 2017 at 8:44 am

      Hi Dan,

      Excel 2016 Professional is not an Office 365 licence so you won’t have Icons with this version of Excel. With your Office 365 licence it depends if you have Excel 2013 or Excel 2016. Only Excel 2016 will have the updates and if you’re not seeing them then it may be because you’re on the Deferred update channel.

      Mynda

      Reply
  4. Ron MVP

    January 2, 2017 at 6:29 am

    Since MS has created second class customers, excluding owners of “real” Office 2016, limiting “new” features to 365, it would make your articles clearer if you made that distinction. Instead of adding the “Update:…” paragraph why not edit your initial statement to say something like “An awesome new feature available in Excel 365 (only!) are Icons.” That makes it immediately clearer that 2016 one-time payment license customers are excluded.

    I was so excited by the feature/button I had not noticed yet that I immediately went to check it out. I only saw your “update” statement after figuring it out myself. Bummer.

    LOL, talk about fast reaction … (I read the rest of the comments after writing this comment)

    PS: I REALLY hate this this function split imposed by “license levels”. It is a return of the bad old days of 1980’s marketing where if you paid more money you got more features in your pre-Office programs. Half of the point of creating the Office bundle back in the 1990’s was to give even students and home users access to ALL features so they could learn them BEFORE they need to use them at work. Shame on MS marketing.

    Reply
    • Mynda Treacy

      January 2, 2017 at 8:51 am

      I agree, Ron. The marketing people certainly haven’t made this transition to their preferred subscription licencing model smooth or fair.

      As I said to Michael, I thought I had been clearer about who the feature was available for, but with all the Christmas and New Year goings on I was slightly distracted and must have dreamt that I’d put that in. It certainly wasn’t my intention to send anyone on a wild goose chase. Lesson learned.

      Unfortunately it’s not as simple as only being available for Office 365 users. If someone were to buy the non-365 version of Excel today they would have them, it’s just existing non-365 users that don’t get the updates.

      Mynda

      Reply
  5. IAN STRYDOM

    January 1, 2017 at 7:06 pm

    I cannot find the insert icon in the illustrations ribbon tab in excel 2016. Please help.

    Reply
    • Mynda Treacy

      January 1, 2017 at 8:08 pm

      Hi Ian,

      New features are only available for Office 365 Excel 2016 users. If you have Office 365 then it may be that you are on the Deferred update channel which hasn’t received them yet. This link has information about the build and release dates and documents what features were included: https://technet.microsoft.com/en-us/office/mt465751.aspx?f=255&MSPPError=-2147217396

      You can see the Icons were in the Dec 6, 2016 update for the ‘Current’ channel.

      Mynda

      Reply
      • Michael (Micky) Avidan

        January 2, 2017 at 5:55 am

        Hi,
        With all due respect my opinion is that it will be for a great benefit if you’ll state, in the future, right at the beginning, something like:
        “An awesome new feature available in Excel 2016 (365) are Icons…” especially in order to avoid users from searching after them in Excel 2016 with no avail.
        Thanks, Michael

        Reply
        • Mynda Treacy

          January 2, 2017 at 8:47 am

          Sorry, Michael. I thought I had written that but with all the Christmas and New Year goings on I was slightly distracted and must have dreamt that I’d put that in. It certainly wasn’t my intention to send anyone on a wild goose chase. Lesson learned.

          Unfortunately it’s not as simple as only being available for Office 365 users. If someone were to buy the non-365 version of Excel today they would have them, it’s just existing non-365 users that don’t get the updates.

          Mynda

          Reply
  6. Jimmy Higgins

    December 31, 2016 at 10:39 pm

    Hi Mynda

    I am using 2010 with no liklihood of moving to 2016 for quite some time and have been using icons from the link below to download images. The only downside is that not every image that shows in the excel gallery when linking an image to a macro is available in these files

    All the very best for 2017 (which I believe is in about 20 mins)

    Reply
    • Mynda Treacy

      January 1, 2017 at 12:51 pm

      Nice find, Jimmy. Thanks for sharing.

      Mynda

      Reply
  7. Patricia A Hernandez

    December 30, 2016 at 11:05 pm

    I have Excel 2016 I do not see the icons.

    Reply
    • Mynda Treacy

      December 31, 2016 at 9:11 am

      Hi Patricia,

      New features are only available for Office 365 Excel 2016 users. If you have Office 365 then it may be that you are on the Deferred update channel which hasn’t received them yet. This link has information about the build and release dates and documents what features were included: https://technet.microsoft.com/en-us/office/mt465751.aspx?f=255&MSPPError=-2147217396

      You can see the Icons were in the Dec 6, 2016 update for the ‘Current’ channel.

      Mynda

      Reply
  8. Gordon Miller

    December 30, 2016 at 2:52 am

    I did not have the “Insert an icon” icon in my Insert ribbon. I have understood that my updates are automatic,but just to be sure, I went to my Microsoft subscription account and downloaded the latest Office 365 Pro Plus and installed it. The “Insert an icon” icon is still not there.

    Reply
  9. Damon

    December 30, 2016 at 2:00 am

    Mynda,

    yours may be on an insider preview release and so can see the new item.

    I’m on current level and its not there yet.
    office version 16.0.6965.2115

    Note, I just ran update, or tried to, and got told I’m current.

    Reply
    • Mynda Treacy

      December 30, 2016 at 8:01 am

      @Gordon and @Damon,

      I’m told by Microsoft that “the Icons feature is 100% rolled out to Current Channel users on Version 1611 (Build 7571.2072) or later.” This link has information about the build and release dates and documents what features were included: https://technet.microsoft.com/en-us/office/mt465751.aspx?f=255&MSPPError=-2147217396

      You can see the Icons were in the Dec 6, 2016 update for the ‘Current’ channel. Perhaps you’re on the Deferred channel.

      Rest assured it will appear soon 🙂

      Mynda

      Reply
  10. Michael Pierce

    December 29, 2016 at 10:52 pm

    This looks great! Sadly, it looks like yet another feature that isn’t available on the Mac version… (I do have Office 365, but no icons.)

    Reply
    • Mynda Treacy

      December 30, 2016 at 7:57 am

      Hi Michael,

      I can’t see why this wouldn’t be available on the Mac version. It may be that it just hasn’t been rolled out yet, or you’re not running the latest version. Give it time, you may well see it soon.

      Mynda

      Reply
      • Ron MVP

        January 2, 2017 at 6:48 am

        Don’t forget that PC and MAC development is done by totally separate teams. It is just a co-incidence that they both have a 2016 release this time. It has been a long time complaint that MAC and PC versions have not had the same features.

        Reply
  11. Abhay

    December 29, 2016 at 9:27 pm

    Is it available only for Office 365? I can’t see this in my Excel 2016 professional plus version

    Reply
    • Mynda Treacy

      December 29, 2016 at 10:21 pm

      Hi Abhay,

      Yes, only Office 365 versions of Excel receive updates, so if your copy of Excel was purchased prior to Icons being added then you won’t see them. It’s one of the techniques Microsoft is using to encourage everyone to switch to the Office 365 subscription model!

      Mynda

      Reply
  12. Дмитрий

    December 29, 2016 at 9:06 pm

    Hi, Mynda.
    Is it in the last Excel update?
    I don’t see icons in my ribbon
    Dmitry

    Reply
    • Mynda Treacy

      December 29, 2016 at 10:22 pm

      Hi Dmitry,

      You may need to update your version of Excel 2016. As far as I’m aware the Icons are in general release now.

      Mynda

      Reply
  13. Mehdi HAMMADI

    December 29, 2016 at 8:54 pm

    Hi Mynda,
    Thank you for sharing but I want to notice that this feature is only available with the O365 subscription and not yet for peaple how have Excel for desktop with a perpetual licence or have I missed some thing ?

    Reply
    • Mynda Treacy

      December 29, 2016 at 10:23 pm

      Hi Mehdi,

      Yes, as I said to Abhay as well, only Office 365 versions of Excel receive updates, so if your copy of Excel was purchased prior to Icons being added then you won’t see them. It’s one of the techniques Microsoft is using to encourage everyone to switch to the Office 365 subscription model!

      Mynda

      Reply

Leave a Reply Cancel reply

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

Current ye@r *

Leave this field empty

Sidebar

More results...

Featured Content

  • 10 Common Excel Mistakes to Avoid
  • Top Excel Functions for Data Analysts
  • Secrets to Building Excel Dashboards in Less Than 15 Minutes
  • Pro Excel Formula Writing Tips
  • Hidden Excel Double-Click Shortcuts
  • Top 10 Intermediate Excel Functions
  • 5 Pro Excel Dashboard Design Tips
  • 5 Excel SUM Function Tricks
  • 239 Excel Keyboard Shortcuts

100 Excel Tips and Tricks eBook

Download Free Tips & Tricks

Subscribe to Our Newsletter

Receive weekly tutorials on Excel, Power Query, Power Pivot, Power BI and More.

We respect your email privacy

Guides and Resources

  • Excel Keyboard Shortcuts
  • Excel Functions
  • Excel Formulas
  • Excel Custom Number Formatting
  • ALT Codes
  • Pivot Tables
  • VLOOKUP
  • VBA
  • Excel Userforms
  • Free Downloads

239 Excel Keyboard Shortcuts

Download Free PDF

Free Webinars

Excel Dashboards Webinar

Watch our free webinars and learn to create Interactive Dashboard Reports in Excel or Power BI

Click Here to Watch Now

mynda treacy microsoft mvpHi, I'm Mynda Treacy and I run MOTH with my husband, Phil. Through our blog, webinars, YouTube channel and courses we hope we can help you learn Excel, Power Pivot and DAX, Power Query, Power BI, and Excel Dashboards.

Blog Categories

  • Excel
  • Excel Charts
  • Excel Dashboard
  • Excel Formulas
  • Excel PivotTables
  • Excel Shortcuts
  • Excel VBA
  • General Tips
  • Online Training
  • Outlook
  • Power Apps
  • Power Automate
  • Power BI
  • Power Pivot
  • Power Query
microsoft mvp logo
trustpilot excellent rating
Secured by Sucuri Badge
MyOnlineTrainingHub on YouTube Mynda Treacy on Linked In Mynda Treacy on Instagram Mynda Treacy on Twitter Mynda Treacy on Pinterest MyOnlineTrainingHub on Facebook
 

Company

  • About My Online Training Hub
  • Disclosure Statement
  • Frequently Asked Questions
  • Guarantee
  • Privacy Policy
  • Terms & Conditions
  • Testimonials
  • Become an Affiliate

Support

  • Contact
  • Forum
  • Helpdesk – For Technical Issues

Copyright © 2023 · My Online Training Hub · All Rights Reserved. Microsoft and the Microsoft Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. Product names, logos, brands, and other trademarks featured or referred to within this website are the property of their respective trademark holders.