Sometimes, when we are work with a spreadsheet, we do not want a cell to "roll" to the next column when we use the copy feature of thespreadsheet. To stop cells from “rolling” we utilize absoluting. The following is an illustration of absoluting Go to cell A23 and type in Number. Go to cell A25 and type in Result. Go to cell C23 and type in a 2 and press the Enter key. We will now create a formula to multiply our numbertimes Net Income. You may use either the Type-in or Point method. Go to cell C25,and type in a formula to multiply cell C23 times cell C19.
The formula should look like this: =C23*C19 The result in C25 should be two times the net income in cell C19. Now copy the formula in cell C25 to cells D25, E25,F25 and G25. Your row 25 should look like the one below. Point to each of the cells D25, E25, F25 and G25. Notice, as you click on each and look at the screen, how C23 (the cell with the 2) "rolled" and became D23, E23, F23 and G23 (which are blank - and caused the "0's"). To do this, we utilize Absoluting or Anchoring. Go back to cell C25. Now we will enter the formula again, but a little differently (to anchor the 2).
Type in a =C23 (or you could type = and point to C23). Now, press the F4 key. Notice, in the Edit bar at the top of the screen, that the =C23 changes to: $C$23. (This tells you that cell C23 is absoluted or anchored. The "$'s" indicate the absoluting.) Now finish the formula by typing in or pointing *C17 as before. Press Enter.
The formula should look like this: =$C$23*C19 Now copy the formula in cell C25 to cells D25, E25,F25 and G25 again.
The numbers should now be correct. Point to cells D25, E25, F25 and G25 (as you did before). You will notice the "$'s" have copied the =$C$23 to each cell (absoluting) and the Net Income figures have rolled as they should. You may practice by changing some more numbers or the income and expense titles.
No comments:
Post a Comment