Home

Excel for Mac saving formulas

Highlighted
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
Average
Janedb in Excel on
5 Replies
Add Selected data 3D maps greyed out.
RobHoekstra in Excel on
0 Replies
Excel formula
Riaan1055 in Excel on
9 Replies
The data model is not updated
aleonc in Excel on
0 Replies
Excel Background
lauracross2020 in Excel on
0 Replies