sharingsunshine
asked on
How To Automate Excel Formula For Multiple Rows
I have Excel 2016 and I need to have this statement executed on 540 rows. How would I set this up to be applied to all of those rows?
This creates a statement out of the combined rows. Currently, I have to increment the cell values manually for each pair.
=SUBSTITUTE(SUBSTITUTE(B$1,"before-value",A3),"after-value",B3)
This creates a statement out of the combined rows. Currently, I have to increment the cell values manually for each pair.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Your welcome.
Quickest way
1.Select the cell
2.Hover the cursor over the bottom right corner of the selected cell until it changes to +
3. Double click and the formula will copy down to the extent of the data
Alternatively, and I think the best way, ist to format the data as an Excel Table. The formula will copy down as rows are added
Overview of Excel tables
This feature of Tables is referred to as Calculated Columns or Fields
Use calculated columns in an Excel table
1.Select the cell
2.Hover the cursor over the bottom right corner of the selected cell until it changes to +
3. Double click and the formula will copy down to the extent of the data
Alternatively, and I think the best way, ist to format the data as an Excel Table. The formula will copy down as rows are added
Overview of Excel tables
This feature of Tables is referred to as Calculated Columns or Fields
Use calculated columns in an Excel table
ASKER