Forum Discussion

deanlevey's avatar
deanlevey
Copper Contributor
Sep 18, 2019

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 columns with formulas as above and/or below it.  Is this possible?

excel

2 Replies

  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor
    Sep 19, 2019

    deanlevey

     

    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

Resources