How to Make a Spreadsheet

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. Open Microsoft Excel....

Method 1 of 3:

Using Microsoft Excel

  1. Picture 1 of How to Make a Spreadsheet
    Open Microsoft Excel. Click or double-click the Excel app icon, which resembles a white "X" on a dark-green background.
  2. Picture 2 of How to Make a Spreadsheet
    Create a blank spreadsheet if you like. If you don't want to use a pre-formatted spreadsheet template, click Blank workbook in the upper-left side of the page, then skip ahead to the "Know where to place your data headers" step.
  3. Picture 3 of How to Make a Spreadsheet
    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. Picture 4 of How to Make a Spreadsheet
    Select a template. Click the template you want to use to do so. The template's window will open.
  5. Picture 5 of How to Make a Spreadsheet
    Click Create. It's on the right side of the template window. Doing so opens the template in Excel.
  6. Picture 6 of How to Make a Spreadsheet
    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.
    1. Skip this step if you aren't using a template.
    2. Some templates use multiple spreadsheets which you can switch between by using the tabs in the lower-left side of the Excel window.
  7. Picture 7 of How to Make a Spreadsheet
    Know where to place your data headers. You'll usually place headers in the 1 row at the top of the sheet.
    1. For example, if you're creating a list of employee names organized by department, you might place one department title in cell A1 and another in cell B1, etc.
  8. Picture 8 of How to Make a Spreadsheet
    Select a cell. Click once the cell in which you want to insert data.
    1. For example, if you want to type the word "Date" into the cell A1, you would click cell A1.
  9. Picture 9 of How to Make a Spreadsheet
    Enter your data. Type in the word, phrase, or figure that you want to enter into the cell.
  10. Picture 10 of How to Make a Spreadsheet
    Save the data. Press ↵ Enter to do so. Your cell's data will be formatted and saved.
  11. Picture 11 of How to Make a Spreadsheet
    Enter any other necessary data. You can fill out the rest of your spreadsheet as you please.
  12. Picture 12 of How to Make a Spreadsheet
    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:
    1. Select an empty cell.
    2. 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)).
    3. Press ↵ Enter.
    4. Review the sum.
  13. Picture 13 of How to Make a Spreadsheet
    Save your file. Press either Ctrl+S (Windows) or ⌘ Command+S (Mac) to open the "Save As" window, then do the following:
    1. Type in the name you want to use for your file.
    2. Select a save location (on a Mac, you may first have to click the "Where" drop-down box).
    3. Click Save.
Method 2 of 3:

Using Apple Numbers

  1. Picture 14 of How to Make a Spreadsheet
    Open
    Picture 15 of How to Make a Spreadsheet
    Numbers. Click or double-click the Numbers app icon, which resembles a series of white, horizontal bars on a light-green background.
  2. Picture 16 of How to Make a Spreadsheet
    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:
    1. Click the All tab in the upper-left side of the Numbers window.
    2. Click the Blank template in the upper-left corner of the page.
    3. Click Choose in the lower-right side of the window.
  3. Picture 17 of How to Make a Spreadsheet
    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.
    1. You can also just scroll down through the list of templates in the middle of the page.
  4. Picture 18 of How to Make a Spreadsheet
    Select a specific template to use. Click once the template you want to use to select it.
  5. Picture 19 of How to Make a Spreadsheet
    Click Choose. It's in the lower-right corner of the window. Your template will open in Numbers.
  6. Picture 20 of How to Make a Spreadsheet
    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.
    1. Skip this step if you aren't using a template.
    2. Some templates use multiple spreadsheets which you can switch between by using the tabs in the lower-left side of the Numbers window.
  7. Picture 21 of How to Make a Spreadsheet
    Know where to place your data headers. You'll usually place headers in the 1 row at the top of the sheet.
    1. For example, if you're creating a list of employee names organized by department, you might place one department title in cell A1 and another in cell B1, etc.
  8. Picture 22 of How to Make a Spreadsheet
    Select a cell. Click once the cell in which you want to insert data.
    1. For example, if you want to type the word "Date" into the cell A1, you would click cell A1.
  9. Picture 23 of How to Make a Spreadsheet
    Enter your data. Type in the word, phrase, or figure that you want to enter into the cell.
  10. Picture 24 of How to Make a Spreadsheet
    Save the data. Press ⏎ Return to do so. Your cell's data will be formatted and saved.
  11. Picture 25 of How to Make a Spreadsheet
    Enter any other necessary data. You can fill out the rest of your spreadsheet as you please.
  12. Picture 26 of How to Make a Spreadsheet
    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:
    1. Select an empty cell.
    2. 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)).
    3. Press ⏎ Return.
    4. Review the sum.
  13. Picture 27 of How to Make a Spreadsheet
    Save your spreadsheet. Once you've finished creating the spreadsheet, you can save it as a file on your computer by doing the following:
    1. Click File in the upper-left corner of the screen.
    2. Click Save As... in the drop-down menu.
    3. Enter a file name.
    4. Select a save location (you may first have to click the "Where" drop-down box to see a list of locations).
    5. Click Save.
Method 3 of 3:

Using Google Sheets

  1. Picture 28 of How to Make a Spreadsheet
    Open the Google Sheets About page. Go to https://www.google.com/sheets/about/ in your computer's web browser.
  2. Picture 29 of How to Make a Spreadsheet
    Click Go 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.
    1. If you aren't logged into a Google Account, you'll need to enter your email address and password when prompted.
  3. Picture 30 of How to Make a Spreadsheet
    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:
    1. Click ☰ in the top-left side of the page.
    2. Click Settings.
    3. Check the "Templates" box.
    4. Click OK.
  4. Picture 31 of How to Make a Spreadsheet
    Create a blank spreadsheet if needed. If you want to create a blank sheet and fill it in as you go, click the Blank option on the left side of the list of templates, then skip ahead to the "Know where to place your data headers" step.
  5. Picture 32 of How to Make a Spreadsheet
    Expand the list of available templates. Click the TEMPLATE GALLERY link in the upper-right side of the page to do so.
  6. Picture 33 of How to Make a Spreadsheet
    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. Picture 34 of How to Make a Spreadsheet
    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.
    1. Skip this step if you aren't using a template.
    2. Some templates use multiple spreadsheets which you can switch between by using the tabs in the lower-left side of the page.
  8. Picture 35 of How to Make a Spreadsheet
    Know where to place your data headers. You'll usually place headers in the 1 row at the top of the sheet.
    1. For example, if you're creating a list of employee names organized by department, you might place one department title in cell A1 and another in cell B1, etc.
  9. Picture 36 of How to Make a Spreadsheet
    Select a cell. Click once the cell in which you want to insert data.
    1. For example, if you want to type the word "Date" into the cell A1, you would click cell A1.
  10. Picture 37 of How to Make a Spreadsheet
    Enter your data. Type in the word, phrase, or figure that you want to enter into the cell.
  11. Picture 38 of How to Make a Spreadsheet
    Save the data. Press ↵ Enter to do so. Your cell's data will be formatted and saved.
  12. Picture 39 of How to Make a Spreadsheet
    Enter any other necessary data. You can fill out the rest of your spreadsheet as you please.
  13. Picture 40 of How to Make a Spreadsheet
    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:
    1. Select an empty cell.
    2. 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)).
    3. Press ↵ Enter.
    4. Review the sum.
  14. Picture 41 of How to Make a Spreadsheet
    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:
    1. Click File in the upper-left side of the Google Sheets page.
    2. Select Download as in the drop-down menu.
    3. Click a file format (e.g., Microsoft Excel (.xlsx)) in the drop-down menu.

Sample Spreadsheets

Picture 42 of How to Make a Spreadsheet
Sample Budget Proposal Spreadsheet
Picture 43 of How to Make a Spreadsheet
Sample Shopping List Spreadsheet
Picture 44 of How to Make a Spreadsheet
Sample Profit and Loss Spreadsheet
Update 05 March 2020
clickcelltemplatewant

You should read it

Maybe you are interested

Category

System

Mac OS X

Hardware

Game

Tech info

Technology

Science

Life

Application

Electric

Program

Mobile