Thread: Cell Reference
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rajesh Rajesh is offline
external usenet poster
 
Posts: 47
Default Cell Reference

Hi

You may fix this by doing the following:

Goto Tools Options Click General Tab under settings untick R1C1
reference style.

Then click ok, now check the coloumn headings.

Regards
rajesh





"Taurien" wrote:

Hi!

I need to know that can we use a particular cell in a formula again and
again. And my excell 2003 is showing numbers in columns but in earlier
versions there used to be Text as A, B and C and so on as columns and i can
use the " $ " sign to fix a cell. but its not working here and cells are
showing as R420C9. but when i cpoy it and paste in the below cell, its
reference is changed. How cani fix it.

Regards