Inserting new row and pasting formulas from previous row

R

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

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
 
Top