Home

excel and sorting

%3CLINGO-SUB%20id%3D%22lingo-sub-757708%22%20slang%3D%22en-US%22%3Eexcel%20and%20sorting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-757708%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20I%20added%20sort%20and%20filter%20to%20my%20excel%20sheet%2C%20my%20columns%20are%20showing%20numbers.%26nbsp%3B%20How%20do%20I%20get%20rid%20of%20the%20Column%20Numbers%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-757708%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-757730%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20and%20sorting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-757730%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F377258%22%20target%3D%22_blank%22%3E%40sharon1231%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20it%20possible%20that%20you%20accidentally%20turned%20on%20R1C1%20reference%20style%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGo%20into%20File%20%26gt%3B%20Options%20%26gt%3B%20Formulas%20%26gt%3B%20%22Working%20with%20formulas%22%20-%20R1C1%20reference%20style%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20this%20helps!%3CBR%20%2F%3EPReagan%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
sharon1231
Occasional Visitor

When I added sort and filter to my excel sheet, my columns are showing numbers.  How do I get rid of the Column Numbers?

1 Reply

Hello @sharon1231,

 

Is it possible that you accidentally turned on R1C1 reference style?

 

Go into File > Options > Formulas > "Working with formulas" - R1C1 reference style

 

Hope this helps!
PReagan 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies