Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy Formulas
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? -- Thanks, Loren |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy Formulas
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Won't copy formulas | Excel Worksheet Functions | |||
automatically copy formulas down columns or copy formulas all the | Excel Worksheet Functions | |||
How do I copy formulas but using the same range each time I copy | Excel Worksheet Functions | |||
copy formulas | Excel Discussion (Misc queries) | |||
Copy Value not formulas | Excel Worksheet Functions |