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
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