Thread: How to copy formula with one cell constant
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mark Mark is offline
external usenet poster
  
Posts: 989
Default How to copy formula with one cell constant
How can I copy the formula so that B2 stays constant and only the row changes?

A B C

1 2

2 10 =A2*B1

3 20 =A3*B1

4 30 =A4*B1


Thanks
Reply With QuoteReply With Quote