Excel 2007 Numerical Column Headers

  • Thread starter Excel 2007 numeric column headers
  • Start date
E

Excel 2007 numeric column headers

My column headers are showing as numeric instead of alphabetic - the only
help I can find online is pre-2007...where's the setting for 2007? Functions
are now EXTEMELY unintuitive...
 
T

Tyro

Office Button/Excel Options/Formulas/Working with formulas - uncheck R1C1
Reference Style

Tyro

"Excel 2007 numeric column headers" <Excel 2007 numeric column
(e-mail address removed)> wrote in message
news:[email protected]...
 
E

Excel 2007 numeric column headers

Not unless somebody at work messed with my computer (which is possible). If
it's set up that way for a particular spreadsheet that I open, will it check
it?

(it worked by the way - Thanks!)
 
T

Tyro

No, R1 C1 Reference Style is Excel level, not workbook level. If if were a
workbook/worksheet option, Excel would state so.

Tyro

"Excel 2007 numeric column headers"
 

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

Column headers 2
How: reset the column headings from numeric to alphabetic? 1
Numeric column headers Excel 2007 2
alter column ref 3
Column Headers in 2007 1
2007, excel column hdings are now numbered - how do I get letters 1
Show Sheet name 2
For Excel 2007 how do yu change column headers from numbers to let 1

Top