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.
Bookmarks