Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy formula question
I have a workbook that contains a formula in many cells:
=$A$1 next cell says = $A$2...etc Ech month i insert a row and although there are $ the fomula when i cut and paste updates prooperly to $b$1 - however this time - it held its A1$A2 - normally i know the dollar signs should mean to hold that cell position but i want to be able to copy into an newly inserted row - without having to remove the $ as i have lots of formulas. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy formula question
You have to watch the $ signs that "fix" the column or row reference.
=$A$1 will stay fixed copying across or down. =A$1 will copy across changing just the Column reference but stay the same copying down. =$A1 will copy down changing the row reference but stay the same copying across. Play with it..................you'll get it. Gord Dibben MS Excel MVP On Thu, 5 Mar 2009 13:16:01 -0800, Belinda7237 wrote: I have a workbook that contains a formula in many cells: =$A$1 next cell says = $A$2...etc Ech month i insert a row and although there are $ the fomula when i cut and paste updates prooperly to $b$1 - however this time - it held its A1$A2 - normally i know the dollar signs should mean to hold that cell position but i want to be able to copy into an newly inserted row - without having to remove the $ as i have lots of formulas. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy down question | Excel Worksheet Functions | |||
Copy/Paste Question | Excel Discussion (Misc queries) | |||
Copy Formula Question | Excel Discussion (Misc queries) | |||
Copy Formula with Linked Cells - Validation Question | Links and Linking in Excel | |||
Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) |