View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JDNETTC JDNETTC is offline
external usenet poster
 
Posts: 8
Default Inserting rows while keeping cell contents the same

When I insert a row, it will give me a blank row. I am trying to insert a
row in the middle of many rows of formulas, and I want the row to be
auto-populated with the correct formula.

Instead of:

Row 1 =kdkdkdk =kdkdkdkd =kdkdkdk
Row 2 (inserted and blank)
Row 3 =kdkdkdkd =kdkdkdkdk =dkdkdk

I want:

Row 1 =kdkdkdk =kdkdkdkd =kdkdkdk
Row 2 (inserted) =kdkdkdkd =kdkdkdkdk =dkdkdk
Row 3 =kdkdkdkd =kdkdkdkdk =dkdkdk

My actual spreadsheet is more complicated, but the principle is what I need
to get working.

JD