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.
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.
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
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.
- Go to File and click on Options.
- On the left side click on “Advanced”.
- 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.
Hold on a second. Was this information helpful so far?
Connect with me:
Boost your Excel skills: Learn the best Excel tricks and tutorials!
Image by Adriano Gadini from Pixabay
