| Home |
| Search |
| Today's Posts |
|
#1
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
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
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
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nesting a sheet name reference within a cell reference??? | Excel Discussion (Misc queries) | |||
| Changing sheet reference to cell reference | Excel Worksheet Functions | |||
| absolute cell reference A spreadsheet cell reference that does no | Excel Discussion (Misc queries) | |||
| problem with cell reference in =sum(offset(cell reference,x,y,z,a)). Want cell ref to be variable. | Excel Worksheet Functions | |||
| Problem with =sum(offset(cell reference,w,x,y,z). I want cell reference to be variable | Excel Worksheet Functions | |||
Linear Mode
