View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Cadillac Williams Cadillac Williams is offline
external usenet poster
 
Posts: 1
Default Microsoft Excel - Automatically Extending Formulas

Hi,

I have a large worksheet that has a number of fairly complex formulas that
are repeated in each row with only the row number reference changing. When I
insert a new row in between two existing rows that contain formulas I would
like excel to automatically insert the formulas I have in the row above it
into my new row. Excel already does this with my formatting, I want to know
how to do it with my formulas as well.