It is time for you to download the manual and read the material in chapter six.
This manual is still usaeble for understanding how to select cell, reference cells and copy and paste. If is free and downloadable AND you can search it-- if you know the terms to search. It is a valuable tool.
when they are contiguous in both the source and destination, you can select the one, then copy, then select the grounp and paste.
In this example there are two tables:
1) a source table
2) s destination table
in the destination table highlight cell A1 then type the "=" (equal sign) :
now click the cell in the source table (A1):
Now hit the return key. Select cell A1, copy. Now select the whole table (or the group of cells you want to reference in the Source table). In this example select all. To select all use the menu item "Edit > Select All":
If you only wanted to reference A1, A3, B4, B6, and B8 you would enter the formula in any cell you want-- I choose A1. Then you select A1, copy, then hold the command key then click those cells, then paste:
cells are name using coordinates (a row and a column). we specify which cell to select by saying the column first, then the row.
I the example I posted I asked you to select cell A1-- that is... the cell at the intersection of column A row 1.
you should say to yourself when entering formulas (as you type the equal sign):
"This cell equals"
the select the combination of cells that combine through what ever mathematical (or formulaic) operations.
Your formula is about the simplest there is. "This cell equals this other cell"
to do this:
1) type the equal sign in the destinartion cell
2) click the source cell
3) hit enter
to fill that same formula into other cells reselect the destination cell (the one you just entered the formula in , then copy
now select another cell(s), paste
to select contiguous cell(s) click the starting cell, the hold the shift key while clicking the last cell
to select non-contiguous cells click the first cell, the hold the command key while click the other cells you wish to add to the selection
once the cells are selected paste