View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Margo Margo is offline
external usenet poster
 
Posts: 18
Default fill column with formula

I want to fill an entire column with the formula in C2, instead of using the
cell drag function. However, when I select FillDown, the entire column is
filled with the header in C1 instead of the formula in C2 - so I end up with
a column filled with Text, instead of the formula dragged down =A2-B2 =A3-B3
etc.