Thread: how to make a formula work for the whole column
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
M Kan M Kan is offline
external usenet poster
  
Posts: 169
Default how to make a formula work for the whole column
Assuming that your data in column B is contiguous, you could just double
click on the grab handle in the lower right hand corner of the cell, when
cell C1 is activated. Alternatively, CTRL C to copy the formula, select
cells C2:C200 and then CTRL V to paste
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"claudia" wrote:

in column c1 the formula is =a1*b1 how to i follow that same formula so that
is go the whole column in c200 is =a200*b200 with out having to enter it 200
times

--
claudia
Reply With QuoteReply With Quote