Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Columns in Excel labeled numbers rather than letters?

All of a sudden the columns in my Excel documents are labeled with numbers
rather than letters. It's making it confusing to do vlookups, etc.

Any suggestions for how this happened and how to undo it?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Columns in Excel labeled numbers rather than letters?

Tools|Options|General Tab|Uncheck "R1C1 reference style"

This is determined by the first workbook you open in that excel session. So if
you happen to open a workbook that someone saved in R1C1 reference style as the
first workbook, you'll have to do it again.

zrossing wrote:

All of a sudden the columns in my Excel documents are labeled with numbers
rather than letters. It's making it confusing to do vlookups, etc.

Any suggestions for how this happened and how to undo it?


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Columns in Excel labeled numbers rather than letters?

Thank you so much! What a relief! :)

"Dave Peterson" wrote:

Tools|Options|General Tab|Uncheck "R1C1 reference style"

This is determined by the first workbook you open in that excel session. So if
you happen to open a workbook that someone saved in R1C1 reference style as the
first workbook, you'll have to do it again.

zrossing wrote:

All of a sudden the columns in my Excel documents are labeled with numbers
rather than letters. It's making it confusing to do vlookups, etc.

Any suggestions for how this happened and how to undo it?


--

Dave Peterson

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
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
change column designators from numbers to letters in excel Mike Setting up and Configuration of Excel 1 January 5th 06 01:35 AM
I have numbers instead of letters on my columns, why? lisawjs Excel Discussion (Misc queries) 3 October 20th 05 07:18 PM
the letters across the top in excel have changed to numbers why popabear New Users to Excel 1 April 7th 05 11:09 PM
ADDING NUMBERS IN COLUMNS ACROSS IN EXCEL lost in translation Excel Worksheet Functions 2 February 4th 05 11:40 PM


All times are GMT +1. The time now is 11:38 PM.

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"