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
2 Seniority Lists
Aminam20 in Excel on
2 Replies
Conditional formatting with wildcard
Rajeev_Raghavan in Excel on
2 Replies
Inconsistency error in the MROUND function
Fleischbender in Excel on
1 Replies
#OVERLOOP!
MarcAdank in Excel on
1 Replies
INDEX MATCH function, avoid duplicate returns
certavi in Excel on
3 Replies