Subtitles of the Movie

There are times when you may need to edit change for delete data in your spreadsheet. Let's say that we need to change the amount for March's electric bill. By selecting that cell and simply typing in a new amount and hitting enter, we will overwrite the contents of that cell. You can also edit a portion of the cell, by selecting it, and using the formula bar at the top of the screen. For instance if I want to change this amount to 80 dollars and 52 cents, I can simply click in the formula bar to place my insertion point or cursor there, hit the backspace key and type the new number in its place. Hitting enter, enters that amount in the cell. To delete a value, once again select the cell, which contains the value you wish to delete and then use the delete key on your keyboard. That value will then be erased. Other methods of deleting values are by going through the menus. Select the value you wish to delete and then go to the edit menu. There is a delete command here, but do not use that to delete a value. That's for deleting entire cells, columns or rows from your spreadsheet. The clear command is the one that you want to use. By moving over into its submenu, you can delete all of the contents of a cell, including the formats or comments you have placed there. You can delete only formats, only comments or the contents, which is what the delete key on the keyboard also does. By selecting contents I've removed that value. To demonstrate what some of the other menu commands can do, I'm going to add some formatting to the contents of January's electric bill. By using buttons on the toolbar, I'm going to make that value bold, and change the font to Arial black. If I don't like that formatting and I wish to only remove the formatting and not the number itself. Go to the edit menu, to clear, and select formats. The reverse can also be done if I like the formatting that I've applied to a cell, for instance making it bold. Let's say, Arial narrow this time. If I just want to delete the contents, I can use the delete key on the keyboard, or go to the edit menu, to clear, to contents. In that way when I enter another formula or value into the cell, the formatting has remained on that cell. To clear both the formatting and the contents of a cell, go to the edit menu to clear and over to all. Now, when I add a new value into that cell and hit enter, the formatting no longer appears on that number. In future lessons we will discuss more about formatting and clearing the contents of entire rows or columns in your spreadsheet. sons we will discuss more about formatting and clearing the contents of entire rows or columns in your spreadsheet.