View original (French)

[Excel] Insert Row while Keeping Formulas

fisico_6403 Posted messages 13 Status Member -  
jc80 Posted messages 5063 Registration date   Status Member Last intervention   -
Hello, I have a little problem with EXCEL. I have a table with quite a few formulas, and when I insert a row in the middle of the table, the new row doesn't have the formulas (although it retains the same formatting)

Is there a setting to make sure that when a row is inserted, it keeps the same formulas as the row below (or above)?

Thanks :)

Configuration: Windows XP / Firefox 3.6.10

3 answers

  1.
    pépé35530 Posted messages 2951 Registration date   Status Member Last intervention   1 390
     
    Hello,

    It seems that there is no specific manipulation to automatically copy formulas when inserting new rows;

    One possibility is to select the row above and use the fill handle to copy down, but in that case, everything will be copied, including manually entered values.

    See you later

    pépé
    4
    1. fisico_6403 Posted messages 13 Status Member
       
      Ah, that's what I thought... thanks anyway.
      0