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...
 
Back
Top