| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do I use r1c1 notation in excel? just doing "=r2c3" not work
I need to use r1c1-style in excel formula.
when I do for example "=r2c3", excel reports an error. How do I use r1c1 style in formula? thanks, |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how do I use r1c1 notation in excel? just doing "=r2c3" not work
If you are entering it into a cell in 2003, you need to set the options
correctly. It's Tools - Options - General Check R1C1 reference style. If that's not the problem, let me know. -- HTH, Barb Reinhardt "sma" wrote: I need to use r1c1-style in excel formula. when I do for example "=r2c3", excel reports an error. How do I use r1c1 style in formula? thanks, |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how do I use r1c1 notation in excel? just doing "=r2c3" not work
To use the r1c1 style, click ToolsOptionsGeneral then check R1C1 Style and
click OK. You can then use that style in formulas, but all formulas must use that style. To change back, simply follow the same path and uncheck the R1C1 Style. "sma" wrote: I need to use r1c1-style in excel formula. when I do for example "=r2c3", excel reports an error. How do I use r1c1 style in formula? thanks, |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how do I use r1c1 notation in excel? just doing "=r2c3" not wo
How did you get the Silver Level contributor to show next to your name?
Thanks, Barb Reinhardt "JLGWhiz" wrote: To use the r1c1 style, click ToolsOptionsGeneral then check R1C1 Style and click OK. You can then use that style in formulas, but all formulas must use that style. To change back, simply follow the same path and uncheck the R1C1 Style. "sma" wrote: I need to use r1c1-style in excel formula. when I do for example "=r2c3", excel reports an error. How do I use r1c1 style in formula? thanks, |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how do I use r1c1 notation in excel? just doing "=r2c3" not wo
I got the bronze first. They show up on their own after so many responses to
postings. "Barb Reinhardt" wrote: How did you get the Silver Level contributor to show next to your name? Thanks, Barb Reinhardt "JLGWhiz" wrote: To use the r1c1 style, click ToolsOptionsGeneral then check R1C1 Style and click OK. You can then use that style in formulas, but all formulas must use that style. To change back, simply follow the same path and uncheck the R1C1 Style. "sma" wrote: I need to use r1c1-style in excel formula. when I do for example "=r2c3", excel reports an error. How do I use r1c1 style in formula? thanks, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| =SUBSTITUTE(C4,"~?#","") will this work to remove multiple string | Excel Worksheet Functions | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| Copying formulas using "+" cell reference causes r1c1 in linked sh | Excel Discussion (Misc queries) | |||
| pictures to work with "data" "sort" option | Excel Discussion (Misc queries) | |||
| Puzzled by statement about R1C1 style in "Escape from Excel Hell" | Excel Discussion (Misc queries) | |||
Linear Mode
