- 0.1 Introduction
- 0.2 The Google Sheets interface
- 1 Toolbar Menu
- 2 Spreadsheet Title
- 3 Collaboration Options
- 4 Shortcut Toolbar
- 5 Column
- 6 Row
- 7 Cell
- 8 Sheets Toolbar
- 9 Formula Bar
- 10 Navigate to Google Sheets Home Screen
- 11 Saved Changes Notification
- 11.1 Cell basics
- 11.2 Understanding cell content
- 11.3 Challenge!
Lesson 8: Getting Started with Google Sheets
Google Sheets allows you to organize, edit, and analyze different types of information using spreadsheets. In this lesson, you ‘ll learn about the different ways you might use spreadsheets and how to navigate the Google Sheets interface. You ‘ll besides learn the basic ways to work with cells and cell content, including how to select cells, insert content, and copy and paste cells .
Watch the video recording below to see an overview of Google Sheets.
All about Google Sheets
Google Sheets is a web-based spreadsheet application that allows you to store and organize different types of information, much like Microsoft Excel. While Google Sheets does not offer all of Excel ‘s advance features, it ‘s easy to create and edit spreadsheets ranging from the bare to the building complex .
While you might think spreadsheets are only used by certain people to process complicate numbers and data, they can actually be used for a kind of everyday tasks. Whether you ‘re starting a budget, planning a garden, or creating an invoice or equitable about anything else you can think of, spreadsheets are a great manner to organize information .
Review the slideshow below to learn some of the other ways you might use spreadsheets .
To create a new Google spreadsheet:
- While viewing your Google Drive, click New and select Google Sheets from the drop-down menu.
- The spreadsheet will appear in a new browser tab.
- To name your spreadsheet, locate and select Untitled spreadsheet at the top of the page. Type a name for your spreadsheet, then press Enter on your keyboard.
- Your spreadsheet will be renamed.
- Whenever you need to view or edit your spreadsheet, you can access it again from your Google Drive, where it will be saved automatically.
You may notice that there is no save button. This is because Google Drive uses autosave, which mechanically and immediately saves your files as you edit them .
The Google Sheets interface
In order to use and edit spreadsheets, you will need to become familiar with the Google Sheets interface .
Click the buttons in the interactional below to learn more about the Google Sheets interface .
You can use the toolbar menu options to edit and modify your spreadsheet in versatile ways. Click a menu and select the desire action from the drop-down list .
By default option, any newly spreadsheet is named ignoble Spreadsheet. Click the title to rename the spreadsheet .
collaboration options allow you to share your spreadsheet with others and make comments as you work .
This toolbar provides convenient shortcut buttons for formatting the data in your spreadsheet, like baptismal font size, textbook conjunction, and text color .
A column is a group of cells that runs vertically from top to bottom. Columns are identified by letters. Column C is selected in this exercise .
A course is a group of cells that runs horizontally from side to side. Rows are identified by numbers. Row 9 is selected in this example.
Each rectangle in a spreadsheet is called a cellular telephone. A cell is the intersection of a course and a column. Click to select a cell. Cell A1 is selected in this exercise .
Every spreadsheet can have multiple sheets. Select the sheet tabs to navigate among sheets, and click the plus signboard ( + ) to add a new sheet .
You can use the recipe stripe to enter and edit data, functions, and formulas for a specific cell .
Click this picture to navigate spinal column to your Google Sheets homepage .
Saved Changes Notification
Google Sheets automatically saves your changes as you work. The saved changes notification lets you know your spreadsheet has been saved .
Every spreadsheet is made up of thousands of rectangles, which are called cells. A cell is the intersection of a row and a column. Columns are identified by letters (A, B, C), while rows are identified by numbers (1, 2, 3) .
Each cell has its own name —or cell address —based on its column and quarrel. In this model, the selected cell intersects column C and row 10, so the cell address is C10. note that a cell ‘s column and row headings become darker when the cellular telephone is selected .
You can besides select multiple cells at the same time. A group of cells is known as a cell range. Rather than a single cell address, you ‘ll refer to a cell rate using the cell address of the first and last cells in the cell range, separated by a colon. For example, a cell stove that included cells A1, A2, A3, A4, and A5 would be written as A1:A5 .
In the images below, two different cell ranges are selected :
- Cell range A2:A8
- Cell range A2:B8
Understanding cell content
Any information you enter into a spreadsheet will be stored in a cellular telephone. Each cell can contain several different types of contented, including text, formatting, formulas, and functions .
- Text: Cells can contain text, such as letters, numbers, and dates.
- Formatting attributes: Cells can contain formatting attributes that change the way letters, numbers, and dates are displayed. For example, percentages can appear as 0.15 or 15%. You can even change a cell’s background color.
- Formulas and functions: Cells can contain formulas and functions that calculate cell values. In our example, SUM(B2:B8) adds the value of each cell in cell range B2:B8 and displays the total in cell B9.
To select cells:
To input or edit cell content, you ‘ll first need to select the cell .
- Click a cell to select it.
- A blue box will appear around the selected cell.
You can besides select cells using the arrow keys on your keyboard .
To select a cell range:
sometimes you may want to select a larger group of cells, or cell range .
- Click and drag the mouse until all of the cells you want to select are highlighted.
- Release the mouse to select the desired cell range.
To insert cell content:
- Select the desired cell.
- Type content into the selected cell, then press Enter. The content will appear in the cell and the formula bar. You can also input content into and edit cell content in the formula bar.
To delete cell content:
- Select the cell you want to delete.
- Press the Delete or Backspace key on your keyboard. The cell’s contents will be deleted.
To copy and paste cells:
It ‘s easy to copy contented that is already entered into your spreadsheet and paste this content to other cells .
- Select the cells you want to copy.
- Press Ctrl+C (Windows) or Command+C (Mac) on your keyboard to copy the cells.
- Select the cell or cells where you want to paste the cells. The copied cells will now have a box around them.
- Press Ctrl+V (Windows) or Command+V (Mac) on your keyboard to paste the cells.
To cut and paste cells:
Unlike replicate and pasting—which duplicates cell content—cutting and pasting moves content between cells .
- Select the cells you want to cut.
- Press Ctrl+X (Windows) or Command+X (Mac) on your keyboard to cut the cells. The cell content will remain in its original location until the cells are pasted.
- Select the cell or cells where you want to paste the cells.
- Press Ctrl+V (Windows) or Command+V (Mac) on your keyboard to paste the cells.
There may be times when you want to copy and paste only sealed parts of a cell ‘s content. In these cases, you can use the Paste Special option. Click Edit in the toolbar menu, hover the mouse over Paste Special, and select your coveted paste option from the drop-down menu .
To drag and drop cells:
quite than cutting and pasting, you can drag and drop cells to move their contents .
- Select a cell, then hover the mouse over an outside edge of the blue box. The cursor will turn into a hand icon.
- Click and drag the cell to its desired location.
- Release the mouse to drop the cell.
To use the fill handle:
There may be times when you want to copy the capacity of one cell to several other cells in your spreadsheet. You could copy and paste the content into each cell, but this method would be time consuming. alternatively, you can use the fill handle to promptly copy and paste contentedness from one cell to any early cells in the lapp row or column.
Read more: WITS: Google Documents
- Select the cell you want to use. A small square—known as the fill handle—will appear in the bottom-right corner of the cell.
- Hover the mouse over the fill handle. The cursor will change to a black cross.
- Click and drag the fill handle over the cells you want to fill. A dotted black line will appear around the cells that will be filled.
- Release the mouse to fill the selected cells.
Using the fill handle to continue a series
The fill handle can besides be used to continue a series. Whenever the contented of a row or column follows a consecutive order—like numbers (1, 2, 3) or days (Monday, Tuesday, Wednesday) —the meet handle will guess what should come future in the series. In our example below, the fill up handle is used to extend a series of dates in a column .
- Open Google Sheets and create a new blank spreadsheet.
- Change the spreadsheet title from Untitled Spreadsheet to Practice Spreadsheet.
- In cell A1, type the date using the format M/D/YY (for example, 5/30/17).
- Use the fill handle to place dates in cells A1:A10.
- Use drag and drop to move the dates to cells B1:B10.
- Delete the content in cell B5.
- When you’re finished, your spreadsheet should look something like this: