[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 answers

I shut down my macbook pro and it starts up by itself

Firefox browser

Compatible graphics card

Computer and rice vinegar

Hello i can’t open excel or word, nor the files

Problem with 3.5" hard drive

Texture issues in enshrouded

Protecting my old phone

Securing an old android phone

Free avast vpn subscription