In this video, we're going to create and name a new spreadsheet, add additional sheets to your spreadsheet, hide, show, reorder sheets within your spreadsheet, copy your spreadsheet, and move your spreadsheet around in Google Drive. Let's start by creating a new spreadsheet. You're starting a new spreadsheet from scratch typingsheets.new in your browser is the fastest way to open a new sheet. If you need help getting started, sheets has tons of templates. If you're an educator, there's a great book template and an assignment tracker. If you're an entrepreneur, there are templates for invoices and expense reports. If you project manage like I do, you might find the template for the project timelines super helpful. There are lots of different scenarios. For our purposes, we're going to start a new spreadsheet from scratch. Open a new window, type drive.google.com, we'll select "New," and go to Google Sheets. Here you can choose between a blank spreadsheet, or you can choose from a template. If you want to check out the entire template gallery, you can visit sheets.google.com to see it all. So now, we have a spreadsheet created. Now, let's give it a title. You'll see that our new spreadsheet is by default labeled untitled spreadsheet. Let's enter a title here, let's type in, Movie Data Project. All right, now, let's add sheets to your spreadsheet. All right, so let's click here to add a new sheet to the spreadsheet. Let's double-click on the sheet tab to rename that sheet. Then click here so we can view all the sheets in our spreadsheet. Now, let's talk about how to hide or show sheets. Sometimes you may want to hide a sheet that you're not using at the moment, for example, maybe we don't want to see the actor sheet, because we're only analyzing the director data. In that case, we can hide the actor sheet like this. Let's select the sheet you want to hide and on the sheet tab, click the down arrow here, you'll select "Hide sheet." As a note this option won't show if your spreadsheet doesn't contain two or more sheets. So to show sheet, return to your "Menu" and select the hidden sheet to make visible again. You can also click" View" and "Hidden sheets" to unhide it. Remember you can see what sheets are visible and which are hidden by the color scheme. Visible sheets will be in bold and hidden sheets will be in gray. If you select a hidden sheet it will show again. Sometimes you may want to reorder a sheet. For example, maybe your team is trying to make a list of all of the actors who appeared on screen in 2016. In that case, we'd move the actor sheet to the left like this. Then moves ahead of the director sheet. You can click and drag around your sheets and reorder them however you'd like. You can see which sheet you've selected down here. It'll have a white overlay. Sometimes I copy a sheet if I feel like the way I've formatted it and plan to change only a few rows, columns, or headers. This approach saves me the time of starting a new sheet from scratch, and then reformatting everything again. So to do that, let's select the sheet tab. We'll click here, to show our choices for this sheet. Let's select "Copy to," then select "New spreadsheet" or "Existing spreadsheet." So the same idea applies if you want to copy an entire spreadsheet. Maybe I like the way this 2016 movie data spreadsheet looks, but I have new data for the current year. I can copy the 2016 spreadsheet and input new data without reinventing the wheel each time. Let's go to "File." Select "Make a copy" and here we have an option to rename the document. Just hit "OK" to copy the spreadsheet, and your copied spreadsheet will open right here in a new tab. Now, let's cover how to move your spreadsheet around in your Google Drive. When you work in a team you have a shared Google Drive, but maybe you don't want to share your spreadsheet until it's just right. In that case, you can work on spreadsheets in your own personal drive, and then move it to another shared folder when you're done. Or maybe you want to put your spreadsheet in a new project folder. Or maybe you put your sheet in the wrong folder and you need to move it to the right folder. Regardless, you'll move a spreadsheet like this. Go to "File," select "Move" and you're going to choose the final destination in your drive wherever you want to put the sheet. Hit "Move here," and there you go. In the next video, 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.
