Home

Formula Management

%3CLINGO-SUB%20id%3D%22lingo-sub-862560%22%20slang%3D%22en-US%22%3EFormula%20Management%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-862560%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20spreadsheet%20with%20hidden%20columns%20including%20formulas%20to%20calculate%20dates%20(project%20schedule).%26nbsp%3B%20When%20I%20insert%20a%20row%20in%20the%20middle%20of%20the%20data%20I%20would%20like%20it%20to%20automatically%20populate%20the%20hidden%20columns%20with%20formulas%20as%20above%20and%2For%20below%20it.%26nbsp%3B%20Is%20this%20possible%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-862560%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-862621%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20Management%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-862621%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F411607%22%20target%3D%22_blank%22%3E%40deanlevey%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETo%20get%20that%2C%20you%20have%20to%20convert%20the%20data%20to%20Table.%3C%2FP%3E%3CP%3EPlease%20check%20out%20this%20%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fcreate-and-format-tables-e81aa349-b006-4f8a-9806-5af9df0ac664%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Elink%3C%2FA%3E%20to%20learn%20more.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-873437%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20Management%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-873437%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F35679%22%20target%3D%22_blank%22%3E%40Haytham%20Amairah%3C%2FA%3E%26nbsp%3BThank%20you%20so%20much%20for%20that!%26nbsp%3B%20worked%20perfectly.%3C%2FP%3E%3C%2FLINGO-BODY%3E
deanlevey
New Contributor

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?

2 Replies

@deanlevey

 

Hi,

 

To get that, you have to convert the data to Table.

Please check out this link to learn more.

 

Regards

@Haytham Amairah Thank you so much for that!  worked perfectly.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies