From the course: Google Sheets Essential Training

Creating, naming, and saving a spreadsheet - Sheets Tutorial

From the course: Google Sheets Essential Training

Start my 1-month free trial Buy for my team

Creating, naming, and saving a spreadsheet

“

- [Instructor] I'm going to show you how to create and name a spreadsheet in Google Sheets and show you how Google Sheets automatically saves your work. To create a new blank spreadsheet from your Google Sheets home screen, click the button with the plus sign on it in the upper left labeled Blank spreadsheet. That will open up a new blank spreadsheet for you to start working with. As soon as you rename or type anything into this spreadsheet, it will automatically be saved for you to your Google Drive. The best thing to do first is to name the spreadsheet so you can easily find it later. Notice, this spreadsheet is named Untitled spreadsheet by default. That's what Google Sheets names all new spreadsheets by default. I'm going to create an inventory spreadsheet, so I'll name my spreadsheet Product Inventory. I'll click away from the title box after I've entered the new spreadsheet name to save it. You'll see a little document status to the right of the name that says Saved to Drive. That's because as soon as you name or type anything into your new spreadsheet, the spreadsheet is automatically saved for you in Google Drive. In fact, every edit is continuously saved for you as you work, as long as you're connected to the internet. To change the name of this spreadsheet, select the spreadsheet name and rename it. I'm going to rename this spreadsheet Solar Product Inventory. You can see if you click the Drive icon to the right of the spreadsheet title, all changes have been saved to Drive. If I click the Move icon next to that, I'll see that the document is saved in my main Google Drive folder now, since I didn't create it in a specific folder. I can find this spreadsheet from my Google Sheets home page by clicking the Sheets home icon in the upper left. The document is on top because it's sorted by Last opened by me. I can also find this spreadsheet in Google Drive. And I can get there from the Sheets menu by clicking the three lines in the upper left and selecting Drive. My spreadsheet's right here on the top, since it's sorted by the last time I modified it. I can also create a spreadsheet right from Google Drive. To create a spreadsheet from Google Drive, I'll click New in the upper left, select Google Sheets, and this time, I'm going to create a new sheet from a template. This takes me to the Google Sheets Template gallery. This time, instead of creating from a blank spreadsheet, I need to create a to-do list for everything I need to do to track inventory. So I'll select the To-do list template. And I'll rename this to-do list Inventory To-do list. I'm going to customize this template and remove the information that's in it currently. I'll add my first task, which is Create Product inventory sheet. Now when I click back to my Google Sheets home screen, I see the two Google Sheets that I made today right on top. You can find several helpful spreadsheet templates in Google's Template gallery. Click Template gallery, and take a look at Google's different templates. You'll find things like a budget template, a schedule, and calendar template, and many more.

Contents