Inserting new row and pasting formulas from previous row
 

Hi,

I have a large spreadsheet, and I have been asked to add a new row and paste
the formulas from the row directly above it. When I do this, the formula
moves from say A1+B3 to A2+B4.

How do I keep it A1+B3???

Inserting new row and pasting formulas from previous row
 

=$A$1+$B$3

will keep the address when pasted


--


Regards,


Peo Sjoblom


"Redsphynx" wrote in message
...
Hi,

I have a large spreadsheet, and I have been asked to add a new row and
paste
the formulas from the row directly above it. When I do this, the formula
moves from say A1+B3 to A2+B4.

How do I keep it A1+B3???

Inserting new row and pasting formulas from previous row
 

Use $ signs

$A$1 + $B$3

"Redsphynx" wrote:

Hi,

I have a large spreadsheet, and I have been asked to add a new row and paste
the formulas from the row directly above it. When I do this, the formula
moves from say A1+B3 to A2+B4.

How do I keep it A1+B3???

Inserting new row and pasting formulas from previous row
 

There are way too many columns for me to go and do this to every single one

"Peo Sjoblom" wrote:

=$A$1+$B$3

will keep the address when pasted


--


Regards,


Peo Sjoblom


"Redsphynx" wrote in message
...
Hi,

I have a large spreadsheet, and I have been asked to add a new row and
paste
the formulas from the row directly above it. When I do this, the formula
moves from say A1+B3 to A2+B4.

How do I keep it A1+B3???

Inserting new row and pasting formulas from previous row
 

I'm not quite sure why you'd want two consecutive rows with the same formula,
but you could try this:

Select the row to copy
Edit|replace
what: = (equal sign)
with: $$$$$=
replace all

Now all the formulas in the selected row are plain old text.
Insert a new row
edit|copy that row
edit|paste to the new row

Select the "sending" row and the "receiving" row and change the text formulas
back to real formulas:

Edit|replace
what: $$$$$=
with: =
replace all



Redsphynx wrote:

Hi,

I have a large spreadsheet, and I have been asked to add a new row and paste
the formulas from the row directly above it. When I do this, the formula
moves from say A1+B3 to A2+B4.

How do I keep it A1+B3???

--

Dave Peterson