Draw tools are greyed out

%3CLINGO-SUB%20id%3D%22lingo-sub-133441%22%20slang%3D%22en-US%22%3EDraw%20tools%20are%20greyed%20out%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-133441%22%20slang%3D%22en-US%22%3E%3CP%3EI%20enabled%20the%20draw%20tools%20tab%20for%20my%20PC%20Excel%202016%2C%20but%20the%20tools%20are%20all%20greyed%20out.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-133441%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-831247%22%20slang%3D%22en-US%22%3ERe%3A%20Draw%20tools%20are%20greyed%20out%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-831247%22%20slang%3D%22en-US%22%3EHi%2C%20all.%20New%20to%20the%20forums.%20Late%20to%20the%20party.%20I%20want%20to%20say%20thanks%20for%20leading%20me%20in%20the%20right%20direction%20for%20this%2C%20and%20I%20would%20like%20to%20add%20that%20my%20particular%20problem%20was%20that%20I%20was%20in%20View%26gt%3BPage%20Layout.%20Draw%20Tool%20seem%20to%20only%20work%20in%20View%26gt%3BNormal%20or%20View%26gt%3BPage%20Break%20Preview.%20Warmest%20Regards%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-140759%22%20slang%3D%22en-US%22%3ERe%3A%20Draw%20tools%20are%20greyed%20out%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-140759%22%20slang%3D%22en-US%22%3E%3CP%3EI%20must%20say%20I%E2%80%99ve%20not%20had%20much%20luck%20with%20the%20%E2%80%9Cofficial%E2%80%9D%20experts%20in%20any%20field.%20The%20clever%20guys%20are%20busy%20elsewhere%2C%20I%20suppose%2C%20and%20customer%20service%20is%20left%20to%20the%20erks.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20problem%20with%20The%20Community%2C%20is%20that%20some%20people%20will%20do%20no%20more%20than%20quote%20%E2%80%9Csolutions%E2%80%9D%20they%E2%80%99ve%20read%20somewhere%2C%20and%20clearly%20haven%E2%80%99t%20actually%20tried%20them.%20%26nbsp%3BSo%20we%20have%20to%20rely%20on%20the%20occasional%20gems.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-140752%22%20slang%3D%22en-US%22%3ERe%3A%20Draw%20tools%20are%20greyed%20out%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-140752%22%20slang%3D%22en-US%22%3E%3CP%3EI%20was%20having%20a%20similar%20issue%20and%20ur%20figuring%20out%20that%20it%20was%20due%20to%20%22freeze%20frame%22%20resolved%20it%20for%20me%20too.%20So%20thanks.%20Thumbs%20up%20to%20the%20Community.%20You%20guys%20do%20a%20far%20far%20better%20job%20than%20Microsoft%20Support.%20My%20attempt%20to%20use%20them%20earlier%20to%20resolve%20this%20issue%20was%20an%20exercise%20in%20futility.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-133570%22%20slang%3D%22en-US%22%3ERe%3A%20Draw%20tools%20are%20greyed%20out%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-133570%22%20slang%3D%22en-US%22%3E%3CP%3ESomething%20strange!%3CSPAN%20class%3D%22%22%3E%3CBR%20%2F%3EIt%20really%20becomes%20gray%20when%20you%20apply%20freeze%20panes!%3C%2FSPAN%3E%3CBR%20%2F%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3EI%20reported%20this%20to%20Microsoft!%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-133561%22%20slang%3D%22en-US%22%3ERe%3A%20Draw%20tools%20are%20greyed%20out%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-133561%22%20slang%3D%22en-US%22%3E%3CP%3EFurther%20to%20my%20previous%20post%2C%20the%20problem%20occurred%20on%20worksheets%20that%26nbsp%3Bused%20the%20%22Freeze%20Panes%2FRows%22%20option.%26nbsp%3B%20Nothing%20to%20do%20with%20the%20%3CSTRONG%3Exlsm%20%3C%2FSTRONG%3Eformat%20after%20all.%26nbsp%3B%20I%26nbsp%3Bunfroze%20a%20top%20row%20and%20the%20%22Draw%22%20items%20lit%20up.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-133530%22%20slang%3D%22en-US%22%3ERe%3A%20Draw%20tools%20are%20greyed%20out%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-133530%22%20slang%3D%22en-US%22%3E%3CP%3EI%20can%E2%80%99t%20check%20that%20at%20the%20moment%2C%20but%20I%20think%20you%E2%80%99ve%20solved%20it%20for%20me.%20%26nbsp%3BThe%20sheet%20isn%E2%80%99t%20protected%20but%20it%20is%20in%26nbsp%3B%3CSTRONG%3Exlsm%26nbsp%3B%3C%2FSTRONG%3Eformat.%20%26nbsp%3BI%20bet%20that%E2%80%99s%20the%20problem.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EMany%20thanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-133502%22%20slang%3D%22en-US%22%3ERe%3A%20Draw%20tools%20are%20greyed%20out%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-133502%22%20slang%3D%22en-US%22%3E%3CP%3EDraw%20tools%20(along%20with%20many%20others)%20are%20disabled%20on%20protected%20sheets.%26nbsp%3B%20Try%20unprotecting%20the%20sheet.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1009210%22%20slang%3D%22en-US%22%3ERe%3A%20Draw%20tools%20are%20greyed%20out%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1009210%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F401083%22%20target%3D%22_blank%22%3E%40Digcoal%3C%2FA%3E%26nbsp%3BCheers%20for%20the%20heads%20up%20on%20this!%20It%20has%20been%20driving%20me%20nuts%20with%20draw%20being%20greyed%20out%20in%20Word.%20Changing%20the%20%22view%22%20from%20%22web%20layout%22%20which%20is%20where%20it%20defaulted%20to%20%22Print%20Layout%22%20enabled%20the%20draw%20tools.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1486090%22%20slang%3D%22en-US%22%3ERe%3A%20Draw%20tools%20are%20greyed%20out%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1486090%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F99530%22%20target%3D%22_blank%22%3E%40acs42%3C%2FA%3E%26nbsp%3B%20They%20are%20greyed%20out%20in%20print%20layout%20view.%20A%20change%20to%20Normal%20view%20enables%20draw%20tools.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1487951%22%20slang%3D%22en-US%22%3ERe%3A%20Draw%20tools%20are%20greyed%20out%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1487951%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F458031%22%20target%3D%22_blank%22%3E%40jcraok%3C%2FA%3E%26nbsp%3B%2C%20same%20thing%20with%20me%20too.%20I%20changed%20the%20document%20view%20to%20%22page%20layout%22%20and%20got%20my%20pens%20back!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1565503%22%20slang%3D%22en-US%22%3ERe%3A%20Draw%20tools%20are%20greyed%20out%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1565503%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F188701%22%20target%3D%22_blank%22%3E%40Adrian%20Long%3C%2FA%3E%26nbsp%3Bi%20was%20able%20to%20draw%20in%20excel%20but%20saving%20the%20doc%20does%20not%20retain%20the%20drawing.%26nbsp%3B%20any%20suggestions%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1565605%22%20slang%3D%22en-US%22%3ERe%3A%20Draw%20tools%20are%20greyed%20out%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1565605%22%20slang%3D%22en-US%22%3E%3CP%3EUnfortunately%2C%20I%20don't%20have%20any%20suggestions%2C%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F749239%22%20target%3D%22_blank%22%3E%40jprugh%3C%2FA%3E.%20I'm%20not%20sure%20if%20I've%20experienced%20that.%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1565830%22%20slang%3D%22en-US%22%3ERe%3A%20Draw%20tools%20are%20greyed%20out%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1565830%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F749239%22%20target%3D%22_blank%22%3E%40jprugh%3C%2FA%3E%26nbsp%3B%20In%20my%20Excel%20for%20Mac%20v16.39%2C%20I%20can%20use%20the%20pens%20to%20draw%2C%20save%20the%20doc%2C%20and%20the%20drawing%20is%20retained.%20%26nbsp%3B%20Tried%20this%20by%20drawing%20across%20cells%20and%20drawing%20over%20a%20chart%20I%20inserted%2C%20and%20in%20both%20cases%20the%20drawing%20was%20retained.%20%26nbsp%3BSo%2C%20can't%20help.%20Sorry.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1716050%22%20slang%3D%22en-US%22%3ERe%3A%20Draw%20tools%20are%20greyed%20out%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1716050%22%20slang%3D%22en-US%22%3EThank%20you%20for%20your%20feedback.%20I%20had%20the%20same%20issue%20on%20my%20SP7%20with%20the%20official%20Microsoft%20Pen.%20The%20solution%20worked%20for%20me.%20As%20mentioned%2C%20the%20Draw%20Tool%20only%20works%20in%20certain%20View%20layouts.%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

I enabled the draw tools tab for my PC Excel 2016, but the tools are all greyed out.

13 Replies
Highlighted

Draw tools (along with many others) are disabled on protected sheets.  Try unprotecting the sheet.

Highlighted

I can’t check that at the moment, but I think you’ve solved it for me.  The sheet isn’t protected but it is in xlsm format.  I bet that’s the problem.

 

Many thanks.

Highlighted

Further to my previous post, the problem occurred on worksheets that used the "Freeze Panes/Rows" option.  Nothing to do with the xlsm format after all.  I unfroze a top row and the "Draw" items lit up.

Highlighted

I was having a similar issue and ur figuring out that it was due to "freeze frame" resolved it for me too. So thanks. Thumbs up to the Community. You guys do a far far better job than Microsoft Support. My attempt to use them earlier to resolve this issue was an exercise in futility. 

Highlighted

I must say I’ve not had much luck with the “official” experts in any field. The clever guys are busy elsewhere, I suppose, and customer service is left to the erks. 

 

The problem with The Community, is that some people will do no more than quote “solutions” they’ve read somewhere, and clearly haven’t actually tried them.  So we have to rely on the occasional gems.

Highlighted
Hi, all. New to the forums. Late to the party. I want to say thanks for leading me in the right direction for this, and I would like to add that my particular problem was that I was in View>Page Layout. Draw Tool seem to only work in View>Normal or View>Page Break Preview. Warmest Regards
Highlighted

@Digcoal Cheers for the heads up on this! It has been driving me nuts with draw being greyed out in Word. Changing the "view" from "web layout" which is where it defaulted to "Print Layout" enabled the draw tools.

Highlighted

@acs42  They are greyed out in print layout view. A change to Normal view enables draw tools.

Highlighted

@jcraok , same thing with me too. I changed the document view to "page layout" and got my pens back! 

Highlighted

@Adrian Long i was able to draw in excel but saving the doc does not retain the drawing.  any suggestions?

 

Highlighted

Unfortunately, I don't have any suggestions, @jprugh. I'm not sure if I've experienced that.    

Highlighted

@jprugh  In my Excel for Mac v16.39, I can use the pens to draw, save the doc, and the drawing is retained.   Tried this by drawing across cells and drawing over a chart I inserted, and in both cases the drawing was retained.  So, can't help. Sorry.

Highlighted
Thank you for your feedback. I had the same issue on my SP7 with the official Microsoft Pen. The solution worked for me. As mentioned, the Draw Tool only works in certain View layouts.