Forum Discussion
automatically fill down the equation cells as the table growths
Hi, I have a table where I gather values from other spreadsheets. Is there a way to automatically fill down the equation cells as the table growths ? for example If I have cells A1:A10/B1:B10...
If you convert your range to a table (Insert tab of the ribbon > click Table), formulas should automatically be propagated to all existing and new rows.
If it doesn't:
- Select File > Options.
- Select Proofing.
- Click 'AutoCorrect Options...'
- Activate the 'AutoFormat As You Type' tab.
- Make sure that the check box 'Fill formulas in tables to create calculated columns' is ticked.