View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Luke M Luke M is offline
external usenet poster
 
Posts: 2,722
Default copying formulas and stuff

Not totally clear what you want, could you post and example?

Possilbe ideas is to write a formula in on cell and copy it over. Excel
adjust formula references based on movement.
E.g.,
=A1
copied to the right becomes
=B1
then, copied down becomes
=B2
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"theE" wrote:

Hi, say you have a list, and you want to calculate the totals of the list,
how would you do that without a data table, and without having to change the
formula for each cell...