Excel column identities
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Plusnet Community
- :
- Forum
- :
- Other forums
- :
- Tech Help - Software/Hardware etc
- :
- Re: Excel column identities
Excel column identities
13 hours ago
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
All of a sudden, any new Excel files have the columns identified with numbers instead of letters - for example R4C7. The older Excel files aren't affected by this - they still identify each cell such as D7.
I haven't been able to find the way back to the older IDs. Does anyone know the cause and the solution, please?
Thankyou
Re: Excel column identities
12 hours ago
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
"R1C1 reference style" is enabled for formulas.
File >> Options >> Formulas >> R1C1 reference style ( tick to enable / clear to disable )
Re: Excel column identities
8 hours ago
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
Thankyou @PhilipHeyes that did the trick. It was well hidden though, and doesn't explain why it got set in the first place.
All the best
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Plusnet Community
- :
- Forum
- :
- Other forums
- :
- Tech Help - Software/Hardware etc
- :
- Re: Excel column identities