| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
keep formulareferenses when adding columns or rows
I wonder if it's possible to keep referenses in a formula when I'm adding a
column or a row? Greatful for a answer |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
keep formulareferenses when adding columns or rows
Probably you should use absolute references like $A$1 instead of relative
ones like A1. Stefi €˛vito€¯ ezt Ć*rta: I wonder if it's possible to keep referenses in a formula when I'm adding a column or a row? Greatful for a answer |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
doesn't help
This doesn't help because when you are adding a column the referenses change
in the formula whether its absolut or relative referenses. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
doesn't help
Then use INDIRECT(ADDRESS()) structure, e.g.
=INDIRECT(ADDRESS(1,4,4,1)) shall always refer to D1. Stefi €˛vito€¯ ezt Ć*rta: This doesn't help because when you are adding a column the referenses change in the formula whether its absolut or relative referenses. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| adding more columns/rows | Excel Discussion (Misc queries) | |||
| Adding up columns for speciic rows | Excel Worksheet Functions | |||
| Adding Rows and columns without harming the formulas | Excel Discussion (Misc queries) | |||
| Adding rows/columns to linked file | Links and Linking in Excel | |||
| adding specifics columns and rows | Excel Worksheet Functions | |||
Hybrid Mode
