Home

Excel for Mac saving formulas

Highlighted
Aussiejt
Occasional Contributor

I am trying to get a quick was to add a formula to a spreadsheet.  I have a spreadsheet that I enter a code into Column A and the formula in Column B to E allow those cells to be auto-filled lining up with a master sheet.

 

If I add another row it does not automatically add the formula and I have to copy and past it.

 

Is there an easier way, such as a way of saving the formula into a preset so I only have to select the row I want the formula added too and click on a preset?

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies