Excel row headings changed!

Jane Quilter 20 Reputation points
2026-07-28T16:16:10.86+00:00

In excel, all my worksheets have changed the row heading to numbers from letters. I dont want this, how do I get it back to original settings

Microsoft 365 and Office | Excel | Other | Windows
0 comments
Answer accepted by question author
EmilyS726 267.8K Reputation points Independent Advisor
2026-07-28T16:52:04.6233333+00:00

In Excel, go to File > Options.> Select Formulas.

Under Working with formulas, clear R1C1 reference style. See if that helps.

Was this answer helpful?

2 people found this answer helpful.

0 additional answers

Sort by: Newest
Most helpful Newest Oldest

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.