Forum Discussion
Draw tools are greyed out
I enabled the draw tools tab for my PC Excel 2016, but the tools are all greyed out.
- 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
jcraok , same thing with me too. I changed the document view to "page layout" and got my pens back!
- 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.
THIS HAS WORKED OUT FOR ME TOO THANKYOU.
- Worked for me. Had to change from "page layout" to "Normal"
Draw tools (along with many others) are disabled on protected sheets. Try unprotecting the sheet.
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.
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.
On the toolbar, click the View tab, and then Print Layout. Return to the Draw tab, and it should no longer be grayed-out.
