View Single Post
  #2  
Old April 18th, 2009, 12:31 AM posted to microsoft.public.excel.worksheet.functions
Sheeloo
external usenet poster
 
Posts: 797
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?