Excel 2013 Does Not Copy Formulas

[oskar270]

I bought a new laptop and I had to transfer my Office 2013 Home & Student from my old laptop to the new one (I did this thru my MS Account). Then I copied all my files to the new SSD.

Among these files I have an accounting file which I use for years and contains 23 columns. The last 16 columns contain formulas to distribute expenses to the appropriate column.

Before when I used to insert a row(s) all formulas were copied to the new row(s) but now I only get blank row(s). Most likely I miss a setting from the Options but I don’t know which one.

How can I get Excel to insert formulas into the new row(s)?

Thanks

[TMS]

Maybe this: https://bettersolutions.com/excel/fo...-expansion.htm

[oskar44]

Maybe this: https://bettersolutions.com/excel/fo...-expansion.htm

Thanks for your time, it did the trick

[TMS]

You're welcome. Thanks for the rep.



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

[oskar44]

Sorry but I cant find how to mark the thread SOLVED

On the Thread Tools there are only 3 entries, Show Printable version, Email this page and Unsubscribe....

I know it should be easy... but I cant find how to edit my first post