Forum Discussion
deanlevey
Sep 18, 2019Copper Contributor
Formula Management
I have a spreadsheet with hidden columns including formulas to calculate dates (project schedule). When I insert a row in the middle of the data I would like it to automatically populate the hidden ...
Haytham Amairah
Sep 19, 2019Silver Contributor
Hi,
To get that, you have to convert the data to Table.
Please check out this https://support.office.com/en-us/article/create-and-format-tables-e81aa349-b006-4f8a-9806-5af9df0ac664 to learn more.
Regards
deanlevey
Sep 24, 2019Copper Contributor
Haytham Amairah Thank you so much for that! worked perfectly.