Hi,
Here I have an issue that I have a table which has formulas. Then I enter new data at the bottom of the table in a new row, the table expands, but the formulas do not copy down, so I need to do it manually. Anyway to do it automatically?
When we add a new row at the bottom, is there a way to specify a range of cells to autofill (there is quite a few), as people keep forgetting there is a formula and paste data rather than drag the cell down.
Thanks!
Copy Down Formula when adding new row at the bottom of the table
-
- NewLounger
- Posts: 5
- Joined: 11 Oct 2021, 15:25
-
- Administrator
- Posts: 78412
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Copy Down Formula when adding new row at the bottom of the table
Welcome to Eileen's Lounge!
Select File > Options (assuming you're on Windows).
Select Proofing in the navigation pane.
Click the 'AutoCorrect Options' button.
Select the 'AutoFormat As You Type' tab.
Make sure that the check box 'Fill formulas in tables to create calculated columns' is ticked.
Select File > Options (assuming you're on Windows).
Select Proofing in the navigation pane.
Click the 'AutoCorrect Options' button.
Select the 'AutoFormat As You Type' tab.
Make sure that the check box 'Fill formulas in tables to create calculated columns' is ticked.
Best wishes,
Hans
Hans