| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas in Excel using [R-1] not A10 references
I converted a Word document into Excel 2003 and when creating formulas,they
are formatted as the cell the formula is in plus or minus a number of rows or columns. An example: =SUM (R[-4]C:R[-1]C). I would like to see these formulas in the regular format referencing Row and Column number i.e. =Sum A1:V52 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formulas in Excel using [R-1] not A10 references
Tools Options, the General tab, uncheck R1C1 reference style
"Drregion" wrote: I converted a Word document into Excel 2003 and when creating formulas,they are formatted as the cell the formula is in plus or minus a number of rows or columns. An example: =SUM (R[-4]C:R[-1]C). I would like to see these formulas in the regular format referencing Row and Column number i.e. =Sum A1:V52 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formulas in Excel using [R-1] not A10 references
That did it! Thank you!
"SVC" wrote: Tools Options, the General tab, uncheck R1C1 reference style "Drregion" wrote: I converted a Word document into Excel 2003 and when creating formulas,they are formatted as the cell the formula is in plus or minus a number of rows or columns. An example: =SUM (R[-4]C:R[-1]C). I would like to see these formulas in the regular format referencing Row and Column number i.e. =Sum A1:V52 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| scalable headings in Microsoft Excel when editing long formulas | Excel Discussion (Misc queries) | |||
| Excel 2002; copy formulas to one workbook to another diff data | Excel Worksheet Functions | |||
| Excel formulas to create large blocks of text | Excel Discussion (Misc queries) | |||
| Excel formulas and recalculation | Excel Discussion (Misc queries) | |||
| Excel should let me use formulas that refer to other cells w/ form | Excel Worksheet Functions | |||
Linear Mode
