Saturday 21 January 2023

How to Use Google Spreadsheets

Learn the Google Sheets basics

Looking for a robust, web browser spreadsheet editor? Google Sheets might be for you! It’s easy to use and has many of the same features as Microsoft Excel. This wikiHow guide will show you how to use Google Spreadsheets on Windows or Mac.

[Edit]Things You Should Know

  • Open a new spreadsheet by going to https://sheets.google.com/ in your web browser.
  • Edit an Excel .xlxs file by uploading it to your drive and opening it in Google Sheets.
  • Enter data into cells. Then, adjust the formatting by using the toolbar or Format tab.
  • Share your spreadsheet by clicking the blue Share button in the top-right of the Sheet.

[Edit]Steps

[Edit]Opening a Spreadsheet

  1. Go to Google Sheets. Enter https://sheets.google.com/ into the URL bar of your web browser. This will take you straight to the Sheets home page.[1]
    Use Google Spreadsheets Step 1 Version 4.jpg
  2. Open a new spreadsheet. Hover over the Plus (+) icon in the bottom right of the Sheets homepage. This will pop up two options:
    Use Google Spreadsheets Step 2 Version 4.jpg
    • Create new spreadsheet opens a blank spreadsheet.
    • Choose template opens the template gallery, where you can choose a premade layout that fits your spreadsheet needs.
    • You can also open a new spreadsheet from Google Drive by clicking the New button and selecting Google Sheets.
  3. Rename your spreadsheet. New spreadsheets will have “Untitled spreadsheet” in the upper-left title box. Click that text and type in the title you want for the spreadsheet.
    Use Google Spreadsheets Step 3 Version 4.jpg

[Edit]Opening an Excel File in Sheets

  1. Upload an .xlsx Excel file to your Google Drive. You can drag and drop the Excel file from your computer’s files (File Explorer on Windows, Finder on macOS) into any Google Drive folder in your web browser.
    Use Google Spreadsheets Step 4 Version 3.jpg
    • Alternatively, click New in Google Drive, then File upload.
  2. Right-click the Excel file. Then, choose Open with > Google Sheets in the pop-up menu. This will open the Excel file in Google Sheets. The formatting and formulas might not be exactly correct.
    Use Google Spreadsheets Step 5 Version 3.jpg
    • The .XLSX icon next to the title in the Google Sheets editor indicates that you’re working on an Excel file. If there’s a red dot notification on this icon, there may be a compatibility issue.

[Edit]Using Google Sheets

  1. Enter data in cells. You can label the first cell of rows and columns to create row and column headers. This can make it easier to organize data, and also works with some Google Sheets features like the chart maker.
    Use Google Spreadsheets Step 6 Version 3.jpg
    • By default, there will be 26 columns (A to Z) and 1000 rows.
    • Add more rows by scrolling to the bottom, entering in an amount next to “more rows at bottom,” and clicking Add.
    • After adding in your data, you can search through the sheet if you’re looking for something specific.
  2. Adjust rows and columns. To edit an entire row (e.g. delete, hide, copy/paste, format), right-click the row number and select an option in the pop-up menu. To edit entire columns, click the drop-down arrow that appears when you hover your cursor over a column's letter.
    Use Google Spreadsheets Step 7 Version 3.jpg
    • You can add a new column or row to a specific location by selecting any cell in the row/column and clicking the Insert tab. You'll see options to insert rows or columns above or below and to the right or left of the selected cell.
  3. Format cells, rows, or columns. To format a cell or range of cells, select those cells by clicking and dragging the cursor over the cells. To format an entire row or column, select its corresponding number or letter. Then, click the Format tab to select a formatting option (e.g. font, font size, bold, italics, data type)
    Use Google Spreadsheets Step 8 Version 3.jpg
    • You can also use the toolbar above the formula box to make formatting changes to a range of cells.
    • When selecting multiple cells (horizontally or vertically), you can merge them so that they span multiple rows or columns.
    • To adjust the way numbers are formatted, go to the Number subsection in the Format tab. You can format numbers in a variety of ways. For example, selecting “Percent” will show numbers as percentages.
  4. Organize data. After selecting a range, you can sort or filter that data by clicking on the Data tab. You can even name ranges of data for easier reference.
    Use Google Spreadsheets Step 9 Version 3.jpg
    • If your data have column headers, go to Sort range > Advanced range sorting options. Check the “Data has header row” box. When you click the Sort by drop-down menu, you can select a column by its header name.
    • The A to Z and Z to A options are ascending and descending respectively. This sorts numbers low-to-high or high-to-low.
    • Filtering your data is a great way to see temporary views of the dataset without changing the spreadsheet.
  5. Insert graphics. Visualizations can be useful when showing others your analysis results. Go to the Insert tab to see options for placing charts, images, links, forms, and drawings.
    Use Google Spreadsheets Step 10 Version 3.jpg
  6. Freeze rows and columns. Go to View > Freeze.
    Use Google Spreadsheets Step 11 Version 3.jpg
    • 1 row or 2 rows will freeze the first 1 or 2 rows.
    • 1 column or 2 columns will freeze the first 1 or 2 columns.
    • To freeze more rows and columns, select the cell that you want to freeze up to. Then, select Up to row NUMBER or Up to column LETTER.
  7. Use functions. You'll find the Functions menu in the Insert tab. Or, in the toolbar, the Functions button is the summation symbol on the right.
    Use Google Spreadsheets Step 12 Version 3.jpg
    • Google Sheets offers most of the same functions found in Microsoft Excel, so those experienced with Excel should find Sheets to be pretty familiar.
    • Advanced users can create their own functions using Google Apps Script. For example, you could create a simple script to add the time and date automatically.
    • Here are a few common Google Sheets functions:
      • IF lets you return a specified value by evaluating a logical expression. This works similarly to using If-Else in Excel.
      • VLOOKUP searches a column for a key value, then returns a cell value in a specific column to the right of the search range. (Check out our Excel guide for this function).
      • SUM adds multiple cell values together. (Same as SUM in Excel).
      • ABS will give you the absolute value of a number.
      • FLOOR rounds a number value down to the closest integer.
      • NPV returns the net present value for an investment given periodic cash flows.

[Edit]Navigation Shortcuts

  1. Use selection and navigation shortcuts. Keyboard shortcuts can save you a ton of time while working on a Google Sheet! Here are a few common shortcuts for Windows:[2]
    Use Google Spreadsheets Step 13 Version 3.jpg
    • Show common keyboard shortcuts — Ctrl + /
    • Select column — Ctrl + Space
    • Select row — Shift + Space
    • Fill down — Ctrl + d
    • Fill right — Ctrl + r
    • Copy, cut, and paste — Ctrl + c, Ctrl + x, and Ctrl + v
    • Move to beginning of sheet — Ctrl + Home
    • Move to beginning or end of a range — Ctrl + Up/Down/Left/Right Arrow
  2. Use macOS shortcuts. Here are the above shortcuts on a Mac:
    Use Google Spreadsheets Step 14 Version 3.jpg
    • Show common keyboard shortcuts — Cmd + /
    • Select column — Ctrl + Space
    • Select row — Shift + Space
    • Fill down — Cmd + d
    • Fill right — Cmd + r
    • Copy, cut, and paste — Cmd + c, Cmd + x, and Cmd + v
    • Move to beginning of sheet — Cmd + Fn + Left Arrow
    • Move to beginning or end of a range — Cmd + Up/Down/Left/Right Arrow

[Edit]Saving & Sharing Spreadsheets

  1. Finalize your spreadsheet. While Google Sheets automatically saves your drafts, you can rename your spreadsheet or make a copy of it before sharing with others. You can find additional options in the File tab.
    Use Google Spreadsheets Step 15 Version 2.jpg
  2. Share your spreadsheet. You can find the Share function under the File tab, or as a blue button in the upper-right corner. Click Share and enter the email addresses of the individuals you want to share the sheet with.
    Use Google Spreadsheets Step 16 Version 2.jpg
    • Sharing a sheet with some means that they can view, comment on, or edit the file directly.
    • There’s also an option to create a shareable link that you can send to people separately.
  3. Download your spreadsheet. If you want a copy of your spreadsheet locally on your computer, select the "Download as" option under the File tab. There are several options, including downloading the document as an Excel (.xlsx) file, .csv, or PDF.
    Use Google Spreadsheets Step 17 Version 2.jpg
  4. Email your spreadsheet. You'll find this option under the File tab. You can either email collaborators (the individuals you've already shared the spreadsheet with), or email the spreadsheet to others as an attachment.
    Use Google Spreadsheets Step 18.jpg

[Edit]Video

[Edit]Tips

  • You can create charts within a spreadsheet, but you can also create a gadget for a chart, pivot table. Gadgets can then be embedded in another web page such as Google Sites. Having gadgets from many spreadsheets embedded in a single page provides a dashboard type view of all the spreadsheets.

[Edit]Related wikiHows

[Edit]References

[Edit]Quick Summary


No comments:

Post a Comment