Buttons For Inserting Images Or Charts In Excel Greyed Out?

You want to add a charts, image or drawing to your Excel workbook, but the buttons are greyed out like in the screenshot below? There might be a simple solution to solve this.

Problem: Buttons to insert charts or images are greyed out in Excel
Problem: Buttons to insert charts or images are greyed out in Excel

Excel FAQ Button

This article is part of our big Excel FAQ.

Learn about all the most frequently asked questions. Or ask a questions yourself!


Reason 1 for greyed out buttons: You are editing a cell

If you are typing in a cell or editing cell content, you cannot insert charts or images. You first have to “leave” the cell.

When you edit a cell (highlighted here) you cannot insert and objects, such as charts or images. The buttons are greyed-out.
When you edit a cell (highlighted here) you cannot insert and objects, such as charts or images. The buttons are greyed out.

So, how to “leave” a cell?

Simply click somewhere in your workbook and press the “Esc” key (pressing the Esc key might be necessary if you edit a formula or function – but please make sure that your edited formula is saved).

Has this solved the problem? If not, proceed with reason number 2 below.

Reason 2: Objects are hidden

excel, options, show, all, drawing, image, missing, chart, geyed out
Images, charts, drawings etc. missing? Click “For objects, show all” within the Excel options.

Within the Excel settings you can choose if objects (including charts and images) should be shown in your workbook. If this setting is set to hide all objects, you cannot insert any new objects so that the buttons are greyed-out.

The setting is called “For objects, show:”. Here you can select if you want to show all objects, including images, charts, drop-down lists and so on. Objects are in general everything which is not inside cells.

  1. Go to File and click on Options.
  2. On the left side click on “Advanced”.
  3. Scroll down to the “Display options for this workbook:”. The last bullet point says “For objects, show:”. Set the tick at “All”.

Now the buttons shouldn’t be greyed out any longer.


Do you want to boost your productivity in Excel?

Get the Professor Excel ribbon!

Add more than 120 great features to Excel!


Reason 3: Worksheet is protected

Sheet protection might prevent users from inserting images.

Another reason is when the worksheet is protected. Depending on the settings of the sheet protection, you might not be allowed to edit objects.

The solution (or course): Unprotect the sheet. In order to do this, go to the Review ribbon and click on “Unprotect Sheet”. It’s possible that you have to enter a password, though.

Image by Adriano Gadini from Pixabay

Henrik Schiffner is a freelance business consultant and software developer. He lives and works in Hamburg, Germany. Besides being an Excel enthusiast he loves photography and sports.

4 comments

  1. The Show All is marked, yet the (Insert) Pictures and entire line (almost) is grayed out. Is that possibly by a deliberate setting by the form creator? I am trying to insert my signature — a .jpg file into my past week time sheet…

    1. Hi Pellervo,

      Thanks for the question. Is it possible that the sheet is protected? This might also prevent you from inserting images (I have also added this reason above).

      Best regards,
      Henrik

  2. Hi Henrik,
    I have to create pie charts and graphs based on an existing spreadsheet. However, the Insert functions are all grey and the -> Charts function is not usable.
    I looked at Options and Review, but couldn’t resolve this. No protection seems to be on.
    Do you have any suggestions what the problem could be?
    Thank you very much in advance.
    Best wishes,
    Rika

  3. My insert option is greyed out. I created the sheet from my own copy of Excel and it’s not protected. Running Windows 10 Home.

Leave a comment

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