Home

Having trouble editing cell that has shape formatting in Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-915932%22%20slang%3D%22en-US%22%3EHaving%20trouble%20editing%20cell%20that%20has%20shape%20formatting%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-915932%22%20slang%3D%22en-US%22%3E%3CP%3Esome%20cells%20show%20shape%20format%20and%20will%20not%20allow%20me%20to%20edit%20the%20cell%20normally.%20how%20do%20I%20disable%20shape%20format%20for%20cells%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-915932%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
walter1414
Occasional Visitor

some cells show shape format and will not allow me to edit the cell normally. how do I disable shape format for cells?

2 Replies
I expect there is a shape placed on top of those cells. Just click on the shape and hit the Del key should get rid of it, unless those shapes are in fact activeX controls.

@walter1414 

Hi

There is a shortcut for hiding All Floating shapes in the worksheet (Shapes, Charts, Pictures...) so if you hide them you will be able to format the cell underneath. The shortcut is CTRL +6

By the way, it's a toggle shortcut.

Hope that helps

Nabil Mourad

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies