Subtitles of the Movie

Data in cells can be relocated in the spreadsheet using the commands for cut, copy and paste, depending on what you want to do with the data. We'll add our rent information to the spreadsheet. Since our rent will be the same amount each month, we'll want to make sure that that same amount is copied into other cells across the row. First, enter the first amount underneath January. Once that's entered select the cell, and since we wish to copy it, we'll go to the edit menu and select the copy command. Notice the keystroke control and the letter C is also available for this command. Once that command is selected you'll see this moving dotted line around the cell. The next step is to place the selection box in the cell where you want that new value to be copied to. So, we'll select the cell C8 for February's rent. The last step is to actually paste the data there. This command is also available in the edt menu. As you can see the amount of 5.40 has been pasted underneath February. You can continue to paste that value into as many cells as you wish. When information is copied it is placed in a area of memory called the clip board. The moving dotted line remains around that cell so that you can see which value is currenly on the clip board. That data remains on the clipboard until you cut or copy another piece of information. So as you can see, I can go to edit to paste again and the same value will be pasted into the cell. To remove this selection dotted line from the origibal value of 540, simply hit your escape key. Next we'll add our cable bill to the list. And we'll enter an amount for that in cell B9. Once that data is entered, we realise that that should have been the amount for February. Since we want to remove it from January and move it into the February cell, we'll use the cut command rather than copy. Once again go to the edit menu and select cut. There's a key stroke associated with this as well, control x. The moving dotted line appears around the cell. Once we paste that information into a different cell, it will disappear from its current location. I'll click in the cell where we want to paste it, and then once again go to the edit menu and select the paste command. Notice cell B9 is now empty and the information has moved to cell C9. There are buttons available for executing the cut, copy and paste commands. If we'd like to copy the same amount into cell D9 for March, we can use the copy command on the standard toolbar. Since copy is not available right now, we'll go to the end of that toolbar and click on the arrows. To show the rest of the buttons available, select the button for copy, then select the cell from March and use the paste command. Notice, a box has appeared on screen along with the Office Assistant. There is an option in Office 2000 to cut several pieces of information at once and then paste them all into a separate area. Now that we've copied this amount of 57.23, let's demonstrate this clipboard that can add many objects to it. I'll select February's rent and copy it using the button on this clipboard. Notice how a second icon has appeared there. When I rest my pointer there it will tell me what value that represents. This one for 5.40 and this one for the 57.23. I'll select the credit card bill for February and select copy again, and then the phone bill for February as well. Notice the box can expand to show up to 12 different pieces of information. So I'll go ahead and select and copy each of the values underneath February. If I then need to paste those values, I can simply select one of the buttons on the clipboard, and that value that is represented will be pasted into the selected cell. In this way you can keep track of cut, copy and paste - many values from around a spreadsheet into other cells. Some other buttons on the clipboard include a command to paste all of the values all at once. To demonstrate this, I'll click in an empty cell, and click paste all. Notice how all the values are copied in order into those cells. If you need to clear the clipboard to start over again, there is a clear clipboard button available. Clicking this will remove all the values that had been cut or copied. The clipboard will appear anytime you execute a cut or copy command two times in a row. If the clipboard does not appear, you can make it appear by going to the view menu, down to toolbars, and over to clipboard. In this way you can show or hide many different toolbars from your screen. When I click on clipboard, this toolbar returns. to the view menu, down to toolbars, and over to clipboard. In this way you can show or hide many different toolbars from your screen. When I click on clipboard, this toolbar returns.