Hi
Please can you give me a solution to my problem.
I have a Table in Excel 2010 and in one column I have a formula. During the year the formula changed . So for example from row 1 to 500 I had my original formula, which must stay, but now I have changed the formula from row 501 onwards.
What my problem is , everytime I add a new row to the Table the formula auto updates buts takes the old formula from Row1 and I have to manually copy my new formula over the old one.
Just for THIS column I do not want excel to Auto correct or update. But for the rest of the table it must keep auto update.
I do not want to cancel the Proofing in the Options , because that will apply to all my spredsheets and files.
Any ideas what can I do.
Please can you give me a solution to my problem.
I have a Table in Excel 2010 and in one column I have a formula. During the year the formula changed . So for example from row 1 to 500 I had my original formula, which must stay, but now I have changed the formula from row 501 onwards.
What my problem is , everytime I add a new row to the Table the formula auto updates buts takes the old formula from Row1 and I have to manually copy my new formula over the old one.
Just for THIS column I do not want excel to Auto correct or update. But for the rest of the table it must keep auto update.
I do not want to cancel the Proofing in the Options , because that will apply to all my spredsheets and files.
Any ideas what can I do.
