Creating and Saving a Spreadsheet

by Allen Wyatt
(last updated November 21, 2013)

Google Sheets allows you to easily create almost any number of spreadsheets you desire. You can have one for your budget figures, another for sales projections, another for time tracking, and any number of other purposes you can think of. The possibilities are virtually limitless, but those possibilities all start with a common task: Creating your spreadsheet. Here are the simple steps to get started:

  1. Log into Google Drive (drive.google.com).
  2. Click the Create button at the left of the screen. Drive presents you with a list of items you can create.
  3. Click Spreadsheet. Drive displays a blank spreadsheet in the Sheets interface.

That's it; you can start entering information right away. If you've used other spreadsheet programs (such as Microsoft Excel) the interface should look immediately comfortable. Don't be afraid to start poking around and trying things out. But be aware that there are differences, as well.

One immediate difference you may notice is that there is no save button, tool, or command in Sheets. That is because the program automatically and continuously saves your information as you enter it. This makes it almost impossible to lose your work, which is a huge benefit. You can be sure that changes are saved because Sheets informs you of this fact just to the right of the menus. (See Figure 1.)

Figure 1. Sheets shows you that it has saved your changes.

When you first create a spreadsheet, Sheets doesn't give it a name. Well, technically it does, but the name is rather generic (Untitled Spreadsheet) and you will probably want to change it to something more descriptive. To do this, just click the current name, shown at the upper-left of the screen, and Sheets presents a dialog box where you can enter a new name. (See Figure 2.)

Figure 2. Changing a spreadsheet's name.

Replace the default name with the name you desire and then click OK. Sheets immediately changes the spreadsheet's name and saves the information. You can now continue developing your spreadsheet as you desire.

When you are done working with the spreadsheet, you can close the browser window or the Google Drive app. When you later log into Google Drive, you'll find the spreadsheet—with the name you gave it—in the list of files maintained within drive. You can click on it to open it and resume working.

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He  is president of Sharon Parq Associates, a computer and publishing services company. ...

MORE FROM ALLEN

Adding Titles to a Chart

Adding titles to either an axis or the chart as a whole can make your data easier to understand. Here's how to add this ...

Discover More

Recognizing a Header Row when Sorting

When you sort data in a worksheet, there are a couple ways you can do it. Using the simple way can result in unsatisfactory ...

Discover More

Hiding Columns Not within a Date Range

Want to automatically hide some columns that don't meet a date criteria that you set? You can't do it automatically, but you ...

Discover More
MORE DRIVETIPS

Adding Borders

Adding borders to a cell (or range of cells) is a common way to draw attention to the cell contents. Sheets provides a ...

Discover More

Searching for a Term in Sheets

Got a need to search the web for more information on something within a spreadsheet? Believe it or not, Sheets provides a ...

Discover More

Changing the Legend Location

When you create a chart, Sheets helpfully adds a legend to better explain the data that is in the chart. If you don't want ...

Discover More

Comments for this tip:

If you would like to add an image to your comment (not an avatar, but an image to help in making the point of your comment), include the characters [{fig}] in your comment text. You’ll be prompted to upload your image when you submit the comment. Images larger than 600px wide or 1000px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted.

What is three minus 1?

There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)


Links and Sharing
  • Ask a Question
  • Make a Comment
  • Free Business Forms
  • Free Calendars
  • Share