View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Keep Same Cell Reference

$A$1

See help for more on relative and absolute references.


Gord Dibben MS Excel MVP


\On Thu, 5 Jul 2007 11:00:02 -0700, 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