Home

Excel for Mac saving formulas

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
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies