Thread
:
Keep Same Cell Reference
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Mike H
external usenet poster
Posts: 11,501
Keep Same Cell Reference
Susan,
use the dollar sign =$a$1
Mike
"Susan" wrote:
If you are referencing a cell in a formula and you want it to remain the same
when you copy and paste the formula into another cell, how do you enter it?
Susan
Reply With Quote
Mike H
View Public Profile
Find all posts by Mike H