Thread: Click and drag a formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default Click and drag a formula
Hi,

Use an absolute reference for the row. The $ sign fixes it

=A$1*C1
Mike

"robdanjoe" wrote:

How do i click and drag a formula while keeping one of the values constant?

ie:
A1*C1
A1*C2
A1*C3

etc,
Reply With QuoteReply With Quote