Thread: How do I keep the exact existing formula when drag copying?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default How do I keep the exact existing formula when drag copying?
Make the references Absolute.

=$A$1 is absolute column and row

$A1 is absolute column and relative row.

A1 is relative row and column

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, 19 Oct 2006 13:43:02 -0700, Excelchallenged
wrote:


Reply With QuoteReply With Quote