Copying work sheet form with formulas

%3CLINGO-SUB%20id%3D%22lingo-sub-1276777%22%20slang%3D%22en-US%22%3ECopying%20work%20sheet%20form%20with%20formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1276777%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%20I%20am%20an%20employer%20that%20is%20using%20the%20CRA's%20spread%20sheet%20for%20the%20%22temporary%20wage%20subsidy%22%20program.%20The%20spread%20sheet%20that%20is%20given%20to%20use%20from%20the%20CRA%20only%20accounts%20for%20up%20to%2026%20employees%20but%20I%20have%2029.%20Is%20there%20a%20easy%20way%20to%20copy%20and%20paste%20a%20page%20that%20has%20formulas%20built%20into%20it%3F%3C%2FP%3E%3CP%3EThank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1276777%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1276807%22%20slang%3D%22en-US%22%3ERe%3A%20Copying%20work%20sheet%20form%20with%20formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1276807%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F606984%22%20target%3D%22_blank%22%3E%40Allsons%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHello%2C%20I%20didnt%20catch%20your%20question%20clearly.%20However%2C%20you%20can%20use%20FORMULATEXT%20function%20to%20display%20a%20formula.%20For%20example%2C%20let%20say%20you%20have%20this%20formula%20in%20cell%20D4%20%3DSUM(A1%3AA5).%20In%20cell%20B1%2C%20you%20can%20execute%20%3DFORMULATEXT(A1).%20When%20you%20press%20enter%2C%20it%20will%20show%20the%20formula%20which%20is%20SUM(A1%3AA5)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hello, I am an employer that is using the CRA's spread sheet for the "temporary wage subsidy" program. The spread sheet that is given to use from the CRA only accounts for up to 26 employees but I have 29. Is there a easy way to copy and paste a page that has formulas built into it?

Thank you!

1 Reply
Highlighted

@Allsons 

 

Hello, I didnt catch your question clearly. However, you can use FORMULATEXT function to display a formula. For example, let say you have this formula in cell D4 =SUM(A1:A5). In cell B1, you can execute =FORMULATEXT(A1). When you press enter, it will show the formula which is SUM(A1:A5)