[Excel] Insert Row while Keeping Formulas

Question

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

pépé35530 · Accepted Answer

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é

olive60 · Answer

Hi,  Actually, there is a way => tables  If you are using Excel 2007, select your data table, go to the "Insert" menu and then "Table."  Once your table is converted into a table, the formula will be automatically copied when you insert a row...  Olive

Vaucluse · Answer

Hello have you tried copying a line and inserting the copy in the same place with the "insert copied cells" option? best regards  -- Let’s ask ourselves if we are not alone in understanding what is being explained?

[Excel] Insert Row while Keeping Formulas

3 réponses

Texture issues in enshrouded

Driver his

Peritel to hdmi conversion

How to access the bios on a compaq notebook

Dsi won't turn on anymore

Search for a song with the lyrics

Left mouse click, touchpad click inactive

Codes stronghold crusader

Stuck computer system repair

Disable write protection mp3 player