Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dave Lock
 
Posts: n/a
Default In Excel the colums which used to be A,B,C D etc are now 1,2,3

Why is this, and how can I change it back to A,B,C etc
  #2   Report Post  
Posted to microsoft.public.excel.misc
SVC
 
Posts: n/a
Default In Excel the colums which used to be A,B,C D etc are now 1,2,3

Tools Options, on the General tab uncheck R1C1 reference style.

"Dave Lock" wrote:

Why is this, and how can I change it back to A,B,C etc

  #3   Report Post  
Posted to microsoft.public.excel.misc
Daniel CHEN
 
Posts: n/a
Default In Excel the colums which used to be A,B,C D etc are now 1,2,3

Go to menu: ToolsOptionsGeneral Uncheck "R1C1 Reference Style"

--
Best regards,
---
Yongjun CHEN
Vice President, CAPST
=================================
XLDataSoft - Data Analysis Expert, Excel/VBA Specialist
- - - - www.XLDataSoft.com - - - -
Free Excel-Based Data Processing Tool is Available for Download
Free Excel / VBA Training Materials is Available for Download
=================================
"Dave Lock" <Dave wrote in message
...
Why is this, and how can I change it back to A,B,C etc



  #4   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph
 
Posts: n/a
Default In Excel the colums which used to be A,B,C D etc are now 1,2,3

"Dave Lock" <Dave wrote in message
...
Why is this, and how can I change it back to A,B,C etc


Tools/ Options/ General
Unset "R1C1 reference style"
--
David Biddulph


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
Getting Excel MDI/SDI/Excel Instance to behave more logically mswlogo Setting up and Configuration of Excel 2 April 23rd 23 11:43 AM
Value Errors with EXCEL XP not showing up in EXCEL 2000 goodguy Links and Linking in Excel 0 July 19th 05 02:38 PM
Excel Range Value issue (Excel 97 Vs Excel 2003) Keeno Excel Discussion (Misc queries) 2 June 13th 05 02:01 PM
i want my excel colums to be rows peter Excel Worksheet Functions 1 March 29th 05 10:37 PM
how can I change the a,b,c, column headers in excel to names espray Excel Discussion (Misc queries) 1 January 13th 05 02:01 AM


All times are GMT +1. The time now is 10:57 PM.

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

About Us

"It's about Microsoft Excel"