The Beginner's Guide to Excel - Excel Basics 2017 Tutorial



How to Make a Spreadsheet

Four Methods:

This wikiHow teaches you how to create a data spreadsheet, which is a document that uses columns and rows to organize data. Commonly used spreadsheet programs include Microsoft Excel, Apple Numbers, and Google Sheets.

Steps

Using Microsoft Excel

  1. Open Microsoft Excel.Click or double-click the Excel app icon, which resembles a white "X" on a dark-green background.
  2. Create a blank spreadsheet if you like.If you don't want to use a pre-formatted spreadsheet template, clickBlank workbookin the upper-left side of the page, then skip ahead to the "Know where to place your data headers" step.
  3. Browse the available templates.Scroll through the list of templates in the Excel window, or type a word or phrase into the text box at the top of the page to search for templates by keyword.
  4. Select a template.Click the template you want to use to do so. The template's window will open.
  5. ClickCreate.It's on the right side of the template window. Doing so opens the template in Excel.
  6. Fill out the template if necessary.If you're using a pre-formatted template, fill out the necessary cells to complete the template, then skip ahead to the "Save your file" step.
    • Skip this step if you aren't using a template.
    • Some templates use multiple spreadsheets which you can switch between by using the tabs in the lower-left side of the Excel window.
  7. Know where to place your data headers.You'll usually place headers in the1row at the top of the sheet.
    • For example, if you're creating a list of employee names organized by department, you might place one department title in cellA1and another in cellB1, etc.
  8. Select a cell.Click once the cell in which you want to insert data.
    • For example, if you want to type the word "Date" into the cellA1, you would click cellA1.
  9. Enter your data.Type in the word, phrase, or figure that you want to enter into the cell.
  10. Save the data.PressEnterto do so. Your cell's data will be formatted and saved.
  11. Enter any other necessary data.You can fill out the rest of your spreadsheet as you please.
  12. Add cells together.If you want to use a cell to combine the results for a list of cells into one sum, you can do the following:
    • Select an empty cell.
    • Type in=SUM(followed by the cells you want to add in "A1,B1,C1" format and a closing parenthesis (e.g.,=SUM(A1,B1)).
    • PressEnter.
    • Review the sum.
  13. Save your file.Press eitherCtrl+S(Windows) orCommand+S(Mac) to open the "Save As" window, then do the following:
    • Type in the name you want to use for your file.
    • Select a save location (on a Mac, you may first have to click the "Where" drop-down box).
    • ClickSave.

Using Apple Numbers

  1. Open Numbers.Click or double-click the Numbers app icon, which resembles a series of white, horizontal bars on a light-green background.
  2. Create a blank spreadsheet if you like.If you want to create a blank spreadsheet, do the following and then skip ahead to the "Know where to place your data headers" step:
    • Click theAlltab in the upper-left side of the Numbers window.
    • Click theBlanktemplate in the upper-left corner of the page.
    • ClickChoosein the lower-right side of the window.
  3. Browse the available template categories.On the left side of the window, you'll see several tabs (e.g.,All,Basic, etc.). Clicking a tab will display a list of templates in that category.
    • You can also just scroll down through the list of templates in the middle of the page.
  4. Select a specific template to use.Click once the template you want to use to select it.
  5. ClickChoose.It's in the lower-right corner of the window. Your template will open in Numbers.
  6. Fill out the template if necessary.If you're using a pre-formatted template, fill out the necessary cells to complete the template, then skip ahead to the "Save your spreadsheet" step.
    • Skip this step if you aren't using a template.
    • Some templates use multiple spreadsheets which you can switch between by using the tabs in the lower-left side of the Numbers window.
  7. Know where to place your data headers.You'll usually place headers in the1row at the top of the sheet.
    • For example, if you're creating a list of employee names organized by department, you might place one department title in cellA1and another in cellB1, etc.
  8. Select a cell.Click once the cell in which you want to insert data.
    • For example, if you want to type the word "Date" into the cellA1, you would click cellA1.
  9. Enter your data.Type in the word, phrase, or figure that you want to enter into the cell.
  10. Save the data.PressReturnto do so. Your cell's data will be formatted and saved.
  11. Enter any other necessary data.You can fill out the rest of your spreadsheet as you please.
  12. Add cells together.If you want to use a cell to combine the results for a list of cells into one sum, you can do the following:
    • Select an empty cell.
    • Type in=SUM(followed by the cells you want to add in "A1,B1,C1" format and a closing parenthesis (e.g.,=SUM(A1,B1)).
    • PressReturn.
    • Review the sum.
  13. Save your spreadsheet.Once you've finished creating the spreadsheet, you can save it as a file on your computer by doing the following:
    • ClickFilein the upper-left corner of the screen.
    • ClickSave As...in the drop-down menu.
    • Enter a file name.
    • Select a save location (you may first have to click the "Where" drop-down box to see a list of locations).
    • ClickSave.

Using Google Sheets

  1. Open the Google Sheets About page.Go to in your computer's web browser.
  2. ClickGo to Google Sheets.It's a blue button at the bottom of the page. Doing so will open the Google Sheets page for your Google Account.
    • If you aren't logged into a Google Account, you'll need to enter your email address and password when prompted.
  3. Prompt templates to appear if necessary.If you don't see a list of templates at the top of the Google Sheets page, you can make them appear by doing the following:
    • Clickin the top-left side of the page.
    • ClickSettings.
    • Check the "Templates" box.
    • ClickOK.
  4. Create a blank spreadsheet if needed.If you want to create a blank sheet and fill it in as you go, click theBlankoption on the left side of the list of templates, then skip ahead to the "Know where to place your data headers" step.
  5. Expand the list of available templates.Click theTEMPLATE GALLERYlink in the upper-right side of the page to do so.
  6. Select a template.Scroll through the list of templates to browse until you find one you want to use, then click it to open it in Google Sheets.
  7. Fill out the template if necessary.If you're using a pre-formatted template, fill out the necessary cells to complete the template, then skip ahead to the "Download your spreadsheet" step.
    • Skip this step if you aren't using a template.
    • Some templates use multiple spreadsheets which you can switch between by using the tabs in the lower-left side of the page.
  8. Know where to place your data headers.You'll usually place headers in the1row at the top of the sheet.
    • For example, if you're creating a list of employee names organized by department, you might place one department title in cellA1and another in cellB1, etc.
  9. Select a cell.Click once the cell in which you want to insert data.
    • For example, if you want to type the word "Date" into the cellA1, you would click cellA1.
  10. Enter your data.Type in the word, phrase, or figure that you want to enter into the cell.
  11. Save the data.PressEnterto do so. Your cell's data will be formatted and saved.
  12. Enter any other necessary data.You can fill out the rest of your spreadsheet as you please.
  13. Add cells together.If you want to use a cell to combine the results for a list of cells into one sum, you can do the following:
    • Select an empty cell.
    • Type in=SUM(followed by the cells you want to add in "A1,B1,C1" format and a closing parenthesis (e.g.,=SUM(A1,B1)).
    • PressEnter.
    • Review the sum.
  14. Download your spreadsheet.Your spreadsheet will be saved in your Google Drive account, but you can download it to your computer as a file by doing the following:
    • ClickFilein the upper-left side of the Google Sheets page.
    • SelectDownload asin the drop-down menu.
    • Click a file format (e.g.,Microsoft Excel (.xlsx)) in the drop-down menu.

Sample Spreadsheets

Community Q&A

Search
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.

Warnings

  • Excel is not free to use, and Numbers is only available for Mac computers.

Made Recently

Loading...
Did you try these steps?
Upload a picture for other readers to see.
Upload error
Awesome picture! Tell us more about it?

Related wikiHows

Article Info

Categories:

In other languages:

Italiano: , Español: , 中文: , Deutsch: , Русский: , Português: , Français: , Bahasa Indonesia: 

Thanks to all authors for creating a page that has been read 87,736 times.





Video: Excel For Beginners (spreadsheets) HD

How to Make a Spreadsheet
How to Make a Spreadsheet images

2019 year
2019 year - How to Make a Spreadsheet pictures

How to Make a Spreadsheet recommend
How to Make a Spreadsheet forecast photo

How to Make a Spreadsheet pics
How to Make a Spreadsheet picture

How to Make a Spreadsheet How to Make a Spreadsheet new foto
How to Make a Spreadsheet new pics

foto How to Make a Spreadsheet
photo How to Make a Spreadsheet

Watch How to Make a Spreadsheet video
Watch How to Make a Spreadsheet video

Discussion on this topic: How to Make a Spreadsheet, how-to-make-a-spreadsheet/
Communication on this topic: How to Make a Spreadsheet, how-to-make-a-spreadsheet/ , how-to-make-a-spreadsheet/

Related News


How to Get a Manuscript Ready for Publication
Reem Acra SpringSummer 2015 Collection – New York Fashion Week
The Geography of Fashion: Why Scandi Fashion Is Becoming More and More Alluring
Clinton Kelly On Trends You Can (And Should) Wear
How to Check Flight Reservations
3 Ways to Make a Beat
20 Stunning Ways to Rock a Sew In Bob
Mom Claims Banana Boat Sunscreen Severely Burned Her Toddler
Meghan Markle will be the first royal fiancée to spend Christmas with the Queen
The 10 Hottest Pink Looks From NYFW 2019
Exclusive: Dame Vivienne Westwood On Dancing, Grandchildren And Making The Scottish Hall Of Fame
How to Unclog the Inner Ear or Eustachian Tube
How to Enjoy the Journey in Baja (for Surfers)
You Can Actually Train Your Hair to Be Less Greasy—Heres How



Date: 06.12.2018, 18:58 / Views: 61555