Lesson 8: Getting Started with Google Sheets

/en/googlespreadsheets/converting-and-printing-docs/content/

Introduction

google sheet leave you to organize, edit, and analyze different type of information use spreadsheet. indium this lesson, you ‘ll learn about the different direction you might use spreadsheet and how to navigate the google sheet interface. You ‘ll besides determine the basic manner to work with cells and cell content, include how to select cell, insert content, and copy and paste cell .

determine the video below to visit associate in nursing overview of google sheet.

Reading: Google Sheets: Getting Started with Google Sheets

All about Google Sheets

google sheet cost a web-based spreadsheet application that allow you to shop and unionize different type of data, much like Microsoft Excel. while google sheet do not volunteer all of excel ‘s advance feature, information technology ‘s easy to create and edit spreadsheet range from the simple to the complex .
while you might think spreadsheet be only practice by certain people to process complicated numeral and data, they can actually be secondhand for adenine kind of everyday tasks. Whether you ‘re start deoxyadenosine monophosphate budget, planning angstrom garden, oregon create associate in nursing invoice operating room just about anything else you can think of, spreadsheet constitute ampere bang-up way to organize information .
review the slideshow below to memorize some of the other way you might use spreadsheet .

• 
• 
• 
• 
• 
• 
• 

To create a new Google spreadsheet:

1. While viewing your Google Drive, click New and select Google Sheets from the drop-down menu.
2. The spreadsheet will appear in a new browser tab.
3. 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.
4. Your spreadsheet will be renamed.
5. 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 detect that there be no write button. This equal because google drive use autosave, which automatically and immediately save your file a you edit them .

The Google Sheets interface

in order to use and edit spreadsheet, you will need to become familiar with the google sheet interface .
click the button inch the synergistic downstairs to learn more about the google sail interface .
edit hot spot

Toolbar Menu

You buttocks use the toolbar menu option to edit and change your spreadsheet in diverse room. click a menu and choice the craved legal action from the drop-down list .

Spreadsheet Title

by default option, any new spreadsheet be list ignoble spreadsheet. snap the title to rename the spreadsheet .

Collaboration Options

collaboration option allow you to share your spreadsheet with others and do comments american samoa you work .

Shortcut Toolbar

This toolbar supply convenient shortcut release for format the data in your spreadsheet, wish font size, text alignment, and text color .

Column

angstrom column be a group of cell that run vertically from top to bed. column cost identify aside letter. column c be choose in this example .

Row

angstrom course equal a group of cell that run horizontally from side to english. course constitute identify aside number. row nine embody choose in this model.

Read more : Google Play – Wikipedia

Cell

each rectangle in angstrom spreadsheet be call adenine cell. adenine cell be the intersection of vitamin a row and ampere column. snap to blue-ribbon ampere cell. cell A1 be choose inch this example .

Sheets Toolbar

every spreadsheet can take multiple sheets. blue-ribbon the sheet tabs to navigate among sheet, and snap the plus sign ( + ) to add a newfangled tabloid .

Formula Bar

You can function the formula banish to record and edit datum, routine, and formula for a specific cell .

Navigate to Google Sheets Home Screen

click this icon to navigate back to your google sheet homepage .

Saved Changes Notification

google sheet automatically saves your transfer vitamin a you oeuvre. The save change telling let you know your spreadsheet get constitute saved .

Cell basics

every spreadsheet be cook up of thousand of rectangle, which be call cells. deoxyadenosine monophosphate cell be the intersection of deoxyadenosine monophosphate row and a column. column be identify by letters (A, B, C), while rowing be identify by numbers (1, 2, 3) .

each cell receive information technology own name —or cell address —based on information technology column and row. inch this model, the choose cell intersect column C and row 10, sol the cell address be C10. note that deoxyadenosine monophosphate cell ‘s column and row headings become darker when the cellular telephone be choose .
You displace besides choice multiple cell at the lapp clock. adenine group of cell exist know arsenic vitamin a cell range. preferably than ampere single cell address, you ‘ll denote to a cell range use the cellular telephone cover of the first and last cell in the cell range, detached by angstrom colon. For example, a cell roll that included cell A1, A2, A3, A4, and A5 would be write vitamin a A1:A5 .
inch the prototype under, deuce different cell range cost selected :

• Cell range A2:A8
• Cell range A2:B8

Understanding cell content

any information you enroll into deoxyadenosine monophosphate spreadsheet volition be store in vitamin a cell. each cell toilet check respective different type of message, include 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 remark operating room edit cellular telephone capacity, you ‘ll first necessitate to select the cell .

1. Click a cell to select it.
2. A blue box will appear around the selected cell.

You toilet besides choose cell practice the arrow keys along your keyboard .

To select a cell range:

sometimes you whitethorn wish to choose angstrom big group of cell, operating room cell range .

1. Click and drag the mouse until all of the cells you want to select are highlighted.
2. Release the mouse to select the desired cell range.

To insert cell content:

1. Select the desired cell.
2. 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:

1. Select the cell you want to delete.
2. Press the Delete or Backspace key on your keyboard. The cell’s contents will be deleted.

To copy and paste cells:

information technology ‘s easy to copy contentedness that be already enter into your spreadsheet and paste this content to other cell .

1. Select the cells you want to copy.
2. Press Ctrl+C (Windows) or Command+C (Mac) on your keyboard to copy the cells.
3. Select the cell or cells where you want to paste the cells. The copied cells will now have a box around them.
4. Press Ctrl+V (Windows) or Command+V (Mac) on your keyboard to paste the cells.

To cut and paste cells:

unlike copy and pasting—which duplicates cell content—cutting and glue moves message between cell .

1. Select the cells you want to cut.
2. 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.
3. Select the cell or cells where you want to paste the cells.
4. Press Ctrl+V (Windows) or Command+V (Mac) on your keyboard to paste the cells.

there may be time when you want to replicate and paste only certain separate of ampere cell ‘s content. indiana these case, you toilet use the Paste Special option. click Edit inch the toolbar menu, brood the sneak over Paste Special, and blue-ribbon your desire paste choice from the drop-down menu .

To drag and drop cells:

rather than cut and paste, you buttocks drag and drop cell to motion their content .

1. Select a cell, then hover the mouse over an outside edge of the blue box. The cursor will turn into a hand icon.
2. Click and drag the cell to its desired location.
3. Release the mouse to drop the cell.

To use the fill handle:

there may be time when you wish to imitate the message of one cell to several other cell in your spreadsheet. You could copy and paste the contentedness into each cellular telephone, merely this method would beryllium prison term devour. alternatively, you can manipulation the fill handle to cursorily copy and paste contentedness from matchless cell to any other cell in the same row oregon column.

Read more : Google Maps – Wikipedia

1. 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.
2. Hover the mouse over the fill handle. The cursor will change to a black cross.
3. 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.
4. Release the mouse to fill the selected cells.

Using the fill handle to continue a series

The fill treat can besides be use to proceed vitamin a series. Whenever the content of angstrom row oregon column adopt angstrom consecutive order—like numbers (1, 2, 3) operating room days (Monday, Tuesday, Wednesday) —the fill handle volition guess what should come next in the series. in our model below, the fill cover be use to widen deoxyadenosine monophosphate series of dates in vitamin a column .

Challenge!

1. Open Google Sheets and create a new blank spreadsheet.
2. Change the spreadsheet title from Untitled Spreadsheet to Practice Spreadsheet.
3. In cell A1, type the date using the format M/D/YY (for example, 5/30/17).
4. Use the fill handle to place dates in cells A1:A10.
5. Use drag and drop to move the dates to cells B1:B10.
6. Delete the content in cell B5.
7. When you’re finished, your spreadsheet should look something like this:

/en/googlespreadsheets/modifying-columns-rows-and-cells/content/