Auto Shapes in Excel is greyed out, what do I do?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an Excel document that I want to add arrows to, but the autoshapes
options are all greyed out. I also tried to cut and paste an arrow from
another excel document, but it would not allow me to paste it. Is there an
option somewhere to turn on/off autoshapes?
 
Could it be due to the fact that you have either worksheet or workbook
protection on? Click TOOLS on the menu and select PROTECTION. If the
UNPROTECT item is in the cascade menu, protection is the issue.
 
Press ctrl/6 (you have tools/options/view/objects/hide all) -- ctrl-6 is a
3-way toggle for show all objects, hide all objects, show placeholders.
Bob Umlas
Excel MVP
 
Nice work..thanks

Bob Umlas said:
Press ctrl/6 (you have tools/options/view/objects/hide all) -- ctrl-6 is a
3-way toggle for show all objects, hide all objects, show placeholders.
Bob Umlas
Excel MVP
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to remove text edit from Autoshapes 4
CANNOT DELETE AUTOPHAPES ARROWS FROM WORKSHEET 3
send color filled shape behind text 3
Auto shapes in excel 2002, SP-2 2
Why do my drop down filters no longer work? 3
autoshape color conditional formating 11
The Sheet-Rename feature is greyed-out in my Excel 2003 workbook.. 1
How do I add an autoshape to a dropdown list in Excel 3

Back
Top