Section: Copying and Pasting formulas

Copy and Paste is magical in a spreadsheet when dealing with formulas.

Let's look at the following snippet of a spreadsheet

NOTE:Need a table

	A	B	C	D
1	Salespeople And Units Sold
2
3	Person	Cars	Trucks	Total
4	Bill	6	11	=B4+C4
5	Mike	11	19
6	Molly	6	13

The logic of the spreadsheet is very simple; we have two columns of numbers (Cars and Trucks) that we want to add together to get a total number of vehicles sold.

The formula in cell D4 is correct; it adds together the right data. Now let's see what happens when we copy that cell and paste it into cell D5.

	A	B	C	D
1	Salespeople And Units Sold
2
3	Person	Cars	Trucks	Total
4	Bill	6	11	=B4+C4
5	Mike	11	19	=B5+C5
6	Molly	6	13