How to Make a Google Spreadsheet: Beginners Guide

IndiaBeats

Editor

posted on 9 years ago — updated on 1 second ago

50
views

If you’re accustomed to creating your spreadsheets using an office suite or software like Excel, you won’t have any issue in creating a Google Spreadsheet. Google Spreadsheet works the same as Excel, and you can do most of the important spreadsheet tasks with it. You can use Google Spreadsheet directly from your web browser or from its mobile app.

Things You Should Know

You'll need a Google account to use Google Sheets, Docs, and Google Drive.
Visit https://docs.google.com/spreadsheets on your computer to access Google Sheets, then click the plus to start a new spreadsheet.
If you have an iPhone or iPad, download Google Sheets from the App Store. On an Android, get Sheets from the Play Store.

Using a Computer

Sign into Google Sheets. Visit docs.google.com/spreadsheets and sign in with your Google or Gmail account. Your Gmail account gives you free access to Google Sheets.

View your existing sheets. Upon logging in, you will be brought to the main directory. If you already have existing spreadsheets, you can see and access them from here.

Create a new spreadsheet. Click the large red circle with a plus sign on the lower right corner. A new window or tab will be opened with the web-based spreadsheet.

Name the spreadsheet. “Untitled spreadsheet” appears on the top left corner. This is the current name of the spreadsheet. Click on it, and a small window will appear. Type in the name of the spreadsheet here, and click the “OK” button. You will see the name immediately change.

Work on the spreadsheet. You can work on Google Sheets much like how you would work on Microsoft Excel. There’s a header menu and a toolbar with functions very similar to those of Microsoft Excel. There’s no need to save with Google Sheets as everything you do is automatically saved at regular intervals.

Exit the spreadsheet when you’re finished. If you’re done with your current document, you can just simply close the window or tab. Everything is saved automatically. You can access your document from Google Sheets or Google Drive.

Using the Mobile App

Launch Google Sheets. The app icon has an icon of a file or spreadsheet on it. If you don’t have Google Sheets, you can download it for free from your device’s respective app store. You can also access your spreadsheets from the Google Drive app.

Sign in with your Google account. If this is the first time you’re using the app, you will need to link it with your Google account first in order for you to access your Google Sheets. Tap the “Get started” button and select your Google account to be used. You may need to enter your Gmail email address and password.

View your sheets. Upon logging in, you will be brought to the main directory. If you already have existing spreadsheets, you can see and access them from here.

Create a new spreadsheet. Tap the large red circle with a plus sign on the lower right corner. You will need to name your new spreadsheet right away. A small window will appear where you can type it in. Do so, then tap the “Create” button. An empty spreadsheet screen will be displayed in full screen.

Work on the spreadsheet. You can work on Google Sheets much like how you would work on Microsoft Excel. There’s a toolbar on the header with functions very similar to those of Microsoft Excel.

Exit the sheet. If you’re done with your current document, tap the checkmark on the top left corner of the header bar, then tap the left arrow. You will be brought back to the main directory. Your changes will be saved automatically.