column headings

A

Aaron Caldwell

Every time i open a new excel file the column headings
come up as numbers rather than letters. How can i change
them back to letters.
Thanks
 
C

Chip Pearson

Aaron,

Go to the Tools menu, choose Options, then the General tab. There,
uncheck the "R1C1 reference style" setting.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Range headings 0
Inconsistent formatting of section numbers 0
Page sort 0
How do I freeze the swimlane headers? 0
Adjusting the layout of over 1000 existing Word documents using a macro-driven batch run 0
White space above heading inconsistently applied 1
Space at end of multi page list to accommodate new entries 1
Print (physical or pdf) not respecting format of source document 0

Top