View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sheeloo Sheeloo is offline
external usenet poster
 
Posts: 793
Default Constant in Excel Formula

Four choices
$A$1 : both column and row do not change while copying
$A1 : row changes while copying down, no change while copying across
A$1 : column changes while copying across, no change while copying down
A1 : both change while copying across or down

"Chele" wrote:

I remember using the $ i think to keep a column constant when doing a
formula. What is it?