PC Review


Reply
Thread Tools Rate Thread

Cells display as R5C5. How do I change it to display E5?

 
 
FinanceTrainer
Guest
Posts: n/a
 
      14th Dec 2009
The default rows and columns on Excel are both displayed in numbers. How do
I change the Columns to display the letters of the alphabet as it did on on
Excel 2003?
 
Reply With Quote
 
 
 
 
Peo Sjoblom
Guest
Posts: n/a
 
      14th Dec 2009
Tools>options>general deselect R1C1 reference style

--


Regards,


Peo Sjoblom


"FinanceTrainer" <(E-Mail Removed)> wrote in message
news:1C5A1C77-F32E-4081-A062-(E-Mail Removed)...
> The default rows and columns on Excel are both displayed in numbers. How
> do
> I change the Columns to display the letters of the alphabet as it did on
> on
> Excel 2003?



 
Reply With Quote
 
מיכאל (מיקי) אבידן
Guest
Posts: n/a
 
      14th Dec 2009
Tools > Options > General > cancel the Reference R1C1 optiion.
Micky


"FinanceTrainer" wrote:

> The default rows and columns on Excel are both displayed in numbers. How do
> I change the Columns to display the letters of the alphabet as it did on on
> Excel 2003?

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to change display format - double click for precedent cells? Hazel Microsoft Excel Misc 0 26th Aug 2008 12:16 PM
change multiple monitor display display, one not working rhambrock65 Windows XP General 7 15th Jun 2008 01:33 AM
some cells display formulas, some display values mvivelo Microsoft Excel Misc 0 27th Mar 2008 09:58 PM
Macro to change cells' display, Pounds, euro, dollars markharris2000@comcast.net Microsoft Excel Discussion 4 1st Sep 2006 09:29 PM
Why does my formula bar display a lengthy string, but my cells display #####? akh2103@gmail.com Microsoft Excel Programming 2 23rd Aug 2006 06:43 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:01 AM.