I have a bunch of cells with formulas I wanna copy to another place and keep it's formulas
But how do I copy them all without the formulas changing also? They move according to the number of cells I'm moving them...
I have a bunch of cells with formulas I wanna copy to another place and keep it's formulas
But how do I copy them all without the formulas changing also? They move according to the number of cells I'm moving them...
One of my preferred methods is to swap out "=".
Select the range to copy
Ctrl+H
Find =
Replace with XXX
Copy
Paste in new location
Ctrl+H
Find XXX
Replace with =
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
Use the clipboard.
To turn on the clipboard click on the Clipboard Dialogue Launcher (little square on lower right corner of the Clipboard on the Home Tab. Set the options that you want for the clipboard. I use Ctrl + C + C to launch and save a copy to the clipboard.
Once saved to the clipboard go to the destination click on the cell, click on the entry in the clipboard and it will be copied (as the original) at the destination.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks