[MUSIC] In this video, we're going to go over how to enter, edit, format, and clear data in a cell. We'll also go over inserting new cells, rows, and columns, and how to drag them around your spreadsheet. So now that we have our spreadsheet all set up, let's start editing it. We're going to go over how to input data into cells, how to format the data, and how to move that data around inside the spreadsheet. See that little blue border outline? That's a pretty handy reminder that'll indicate which cell you're working on. So go ahead and clear that content, and let's just add it back in, because we're going to use it later. Just wanted to show you how to do that real quick. Let's click on a cell, or you can also select a range of cells. So go ahead and clear that content, and now enter your new content. You can format your data in several different ways in Google Sheets so that everything is displayed just how you want it. Google Sheets automatically formats your data, but we can also apply custom formatting of numbers, dates, and currencies. One thing to keep in mind when you're importing data from an external source is that it might not be formatted exactly the way you like. A tip is to make your imported data plain text. This will make it easy to format everything consistently later. So let's make it plain text. Select the column or the row that you want to modify, open Format, go to Number, and then choose Plain text here. Okay, so we know our data is all in plain text, cool. As you can see from our movie data set, we have a few different formats in the spreadsheet. Here we have dates, and here we have currency. Let's modify the date format to show the year first. Later, we'll sort the sheet by year, so let's change the formatting now. Here our budget column is talking about dollars, so we want to change the format to represent currency. Let's do that. Okay, now it's currency. The movie data set that we're working with uses round numbers for the budgets, so there's no reason for us to show the cents in our spreadsheet, because it just takes up space. Sheets has the option to decrease the precision and decimal places, so let's do that. Remove decimal places in the budget column. So select the budget column, or you can select the 123 icon in the toolbar here. Set it to currency to decrease the precision and decimal places. That's optional. Or you can also select the shortcut on the toolbar, the .0 or the .00, to decrease or increase the precision. Okay, now let's clear formatting in a cell. Let's say this data point was bolded and italicized, and we wanted to clear that styling. The easiest way to do so would be to highlight the cell or range of cells, select Format, and then select Clear formatting. This will send the data back to default. You may need to add a cell, row, or column to your spreadsheet. This is especially true if you are given a data set, but you want to add more detail to it, or if you want to do some additional analysis. We'll use our movie spreadsheet to show this. Maybe our producer has asked us to create a checklist of the genres to research more thoroughly. So we want to create a new column on our genre sheet. Let's select the new column location. Open Column, select Insert 1 left or Insert 1 right to add a column. That's one way to insert a column. Here's another way. We'll select Insert, and then we'll select Column left or Column right. Inserting multiple columns or rows is simple. Just highlight the number of columns you'd want to insert. As an example, let's insert 5, so select 5 columns, right-click, and you'll see this option to Insert 5 left or Insert 5 right, cool. Now let's go through the same process to add a new row. Select where you want to add a new row, and open the Insert menu. I'm going to click here. You'll notice that the insert options have changed. So instead of columns, we can insert a new row above or below the selection. You can also access the same menu options by using the right-click menu option. Here you can also choose to delete row, delete column, or delete cells. Let's say we want the box office revenue column to be right next to the release date column. We can move it like this. Select the column, click, hold, and drag to where you want it. And select the row, you click, hold, and drag to where you want it. Okay, so we just went over how to enter, edit, format, and clear data in a cell. You also learned how to insert new cells, new rows, new columns, and how to drag them all around in your spreadsheet. In the next video, you'll learn how to duplicate, print, and publish your spreadsheet. [MUSIC]
