View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David Billigmeier
 
Posts: n/a
Default absolute cell reference A spreadsheet cell reference that does no

Well help with what!?

Enter your question in the Body of the message instead of the Subject line.
Your question got cut off!!

Do you just want to use an absolute reference? If so enter $'s around your
cell reference:

$A$1 -or- $A1 -or- A$1

A $ preceding the column reference ensures the column letter doesn't change.
A $ preceding the row reference ensures the row number doesn't change.

Does that help?
--
Regards,
Dave


"help" wrote:

help