Thread: How to make a cell address remain constant when copying a formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default How to make a cell address remain constant when copying a formula
Deana


The $ sign is used to change cell references from "relative" to absolute". This
fixes the reference so's it will not change as copied down or across.

$A1 is absolute column and relative row.

$A$1 is absolute column and row.

A$1 is relative row and absolute column.

See help on relative and absolute cell references for more on this.


Gord Dibben MS Excel MVP

On Thu, 7 Sep 2006 11:52:01 -0700, Deana
wrote:


Gord Dibben MS Excel MVP
Reply With QuoteReply With Quote