>>I may be misunderstanding.
>>
>>If you're doing it manually, you just select a range and paste with one operation. If you're looking to anchor the original value in all cases, paste into the first, change the related cells to something like $A$1 to lock it, then copy that one, select the range, and paste from that one.
>
>I have cell A55 which contains a label. I need that label to be used dynamically in cells E5, K5, and Q5. In cell E5, I have entered =A55. That works. Now, I need to copy that formula in K4 and Q5. However, a copy/paste changes the formula. Then, I tried all kinds of paste. None was able to copy the formula in those two cells.
Are you trying to make K5 and Q5 both also say =A55? If so, you nee to change it in E5 to say =$A$55, and then copy and paste and it will maintain that reference to =A55 as you move it around to other cells.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only