Thread: Copy formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Chuck Chuck is offline
external usenet poster
 
Posts: 90
Default Copy formula

how can i copy a formula from one row to another with out changing the
refrences and with out using absolute refrences "$" eg. In row 2 i have
=average(B200:B300) I want to copy the exact formula into row 20 with out
having to change the formula in row 2 to =average(B$200:B$300) is this
possible?