Copy Formulas

L

Loren

I have a bunch of formulas set up in one column (column D) that uses some
figures in 6 hidden columns (columns F thru K). I want to use the same
formulas set up in column D in column M but when I highlight column D and
click copy then go to column M and hit paste everything that is in the hidden
columns is shifted to the right of column M just like the things in column D
are to its right. I've tried everything in the Paste Special and nothing
there works either. How do I do this wirhout having to retype every formula
over since I need these formulas in 6 seperate columns?
 
D

Dave O

Try this on for size:
~ highlight the formulas you want to move
~ do a search and replace: search for the = sign and replace with your
initials. This converts the formulas from a dynamic Excel math thing
into a static text string, and Excel will not shift the formula
references
~ copy the range
~ paste into the new location
~ search and replace again: search for your initials, replace with the
= sign
~ take a $20 out of petty cash, and treat yourself to lunch
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top