Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 31
Default Why are my Columns labeled with Numbers rather than letters?

For some reason, in Excel 2009, all of my column headers are now Numbers
rather than letters. Is there a setting within Excel or a fast-key that
automatically changed this without me looking?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,805
Default Why are my Columns labeled with Numbers rather than letters?

Did you mean Excel 2003? If yers, then read on...

To change this behavior, follow these steps:

1. Start Microsoft Excel.
2. On the Tools menu, click Options.
3. Click the General tab.
4. Under Settings, click to clear the R1C1 reference style check box
(upper-left corner), and then click OK.

If you select the R1C1 reference style check box, Excel changes the
reference style of both row and column headings, and cell references from the
A1 style to the R1C1 style.

In Excel 2007
Office Button-Excel Options-FORMULAS-WORKING WITH FORMULAS
click to clear the R1C1 reference style check box
"DaveM" wrote:

For some reason, in Excel 2009, all of my column headers are now Numbers
rather than letters. Is there a setting within Excel or a fast-key that
automatically changed this without me looking?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Columns labeled with numbers not letters plumeria54 Excel Worksheet Functions 9 April 22nd 10 01:40 PM
Columns are labeled as numbers in the grid!! Dinosaur Pete Excel Discussion (Misc queries) 2 September 30th 08 07:41 PM
I have columns labeled as numbers instead alpha why? Ajay Chadha Excel Discussion (Misc queries) 2 September 26th 08 07:04 PM
Columns Labeled Wendy Excel Discussion (Misc queries) 1 April 18th 07 12:41 AM
Columns in Excel labeled numbers rather than letters? zrossing Excel Discussion (Misc queries) 2 October 19th 06 06:13 PM


All times are GMT +1. The time now is 09:58 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"