hI EVERYONE, i need to copy everything from A2:A5 to AV2:AV5 there are lots of formulas, is there a way to copy paste all without the formulas changing and having to write in all the formulas $ since doing that would make me have to work for at least 2 hours changing all of that...any help please!
hello
try this one.
Select the range of cells you want to copy.
Select Edit » Replace...,
and in the Find What: box, type*=(an equals sign).
In the Replace With: box, type*symbol you are sure is not being used in any of the formulas.
Click Replace All.
All the formulas will appear on your worksheet with your symbol*in place of an*=
You can simply copy this range, paste it to the destination you desire,
Then select the range, and select Edit » Replace.... This time, replace the*symbol*with an*=
Your formulas will reference the same cell references as your originals.
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
thks so much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks