View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Alex[_3_] Alex[_3_] is offline
external usenet poster
 
Posts: 1
Default Auto Fill help. Thanks in advance

I would like to auto fill the following formula ex: A1*B1, A2*B1, A3*B1. The
auto Fill automatically changes the B column with the same number as the A.
Is there a way to keep the second number static?

Thanks.

Alex