View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Fred is offline
external usenet poster
 
Posts: 90
Default Repeat formula with inserted row

Hi, really need some help with the new Excel.

In row 7 I have it setup that K7=(H7-E7) and so row 8 is K8=(H8-E8).
Trouble I am having is that when I "insert" row 9 the formula does not repeat
and I have to type K9=(H9-E9). What or how do I have to set it up so that
any time I "insert" a row that it understands it needs to repeat the formula
from the row above it?

Thanks!