|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
August 27th, 2008, 08:43 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell Reference
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 
|
|
#2
August 27th, 2008, 08:53 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
|
|
#3
August 27th, 2008, 09:17 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Cell Reference
Thanks Rajesh it worked and changed the column headings and then i put "$"
sign and my formula worked. Thanks man. What do u do man and where u live "rajesh" wrote: 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
|
|
#4
August 27th, 2008, 09:26 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Cell Reference
Your welcome. I am in india & my profession is finance & accounts.
"Taurien" wrote: Thanks Rajesh it worked and changed the column headings and then i put "$" sign and my formula worked. Thanks man. What do u do man and where u live "rajesh" wrote: 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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
