0
0
Excelspreadsheet~10 mins

Recording macros in Excel - Cell-by-Cell Formula Trace

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Sample Data

A simple list of items and their prices to demonstrate macro recording.

CellValue
A1Item
B1Price
A2Apple
B21.00
A3Banana
B30.50
A4Cherry
B42.00
Formula Trace
No formula used; macro records user actions like formatting and typing.
Step 1: User selects cells B2:B4
Step 2: User applies currency format to selected cells
Step 3: User types formula =SUM(B2:B4) in cell B5
Step 4: User stops macro recording
Cell Reference Map
    A       B
1 | Item  | Price  |
2 | Apple | 1.00   |
3 | Banana| 0.50   |
4 | Cherry| 2.00   |
5 |       | =SUM(B2:B4) |

Arrows: B5 formula references B2, B3, B4
Cells B2 to B4 are referenced by the formula in B5 to calculate total price.
Result
    A       B
1 | Item  | Price  |
2 | Apple | $1.00  |
3 | Banana| $0.50  |
4 | Cherry| $2.00  |
5 |       | 3.50   |

Currency format applied to B2:B4 and sum formula in B5.
Final sheet shows prices formatted as currency and total price calculated in B5.
Sheet Trace Quiz - 3 Questions
Test your understanding
What does the macro record when you select cells B2:B4?
AIt records the selection of those cells.
BIt records deleting the cells.
CIt records copying the cells.
DIt records formatting the entire sheet.
Key Result
Recording macros captures user actions like selecting cells, formatting, and typing formulas step-by-step.