Quote Originally Posted by MIKE0W
How can I copy a forumla and only update part of on none of it and keep original information. when I copy it it assumes that I want to adjust the cells also is there a way to keep the original forumla or if I have a two part cell line =sum(a6*b3) and i want the be to change to the coppied cell but a6 to remain locked. thanks for the help.


Use the $ sign:

=SUM($A$6*b3)...

This will keep column a and row 6 static (absolute)...but make b3 relative.
Is this what you are looking for? Have a great day.