Inserting new row and pasting formulas from previous row

[Redsphynx]

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???

 

[Peo Sjoblom]

=$A$1+$B$3

will keep the address when pasted


--


Regards,


Peo Sjoblom

 

[akphidelt]

Use $ signs

$A$1 + $B$3

 

[Redsphynx]

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

 

[Dave Peterson]

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