Apr 23 2021 07:29 PM
Apr 23 2021 10:54 PM
Hi,
You can do it with the following rules:
1-Go to the File tab on the Ribbon.
2-Choose Options.
3-Choose Proofing.
4-Click on the AutoCorrect Options button.
5-Choose the AutoFormat As You Type tab (if not already selected).
6-Check the box that says Fill formulas in tables to create calculated columns.
7-Hit OK.
The following link will be useful:
https://www.excelcampus.com/tables/prevent-table-formula-autofill/