3 Ways to Create a Sheet

Table of contents:

3 Ways to Create a Sheet
3 Ways to Create a Sheet

Video: 3 Ways to Create a Sheet

Video: 3 Ways to Create a Sheet
Video: Make a Tri-fold Brochure in Word 2024, November
Anonim

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

Step

Method 1 of 3: Using Microsoft Excel

Make a Spreadsheet Step 1
Make a Spreadsheet Step 1

Step 1. Open Microsoft Excel

Click or double-click the Excel icon, which looks like a white “X” on a dark green background.

Make a Spreadsheet Step 2
Make a Spreadsheet Step 2

Step 2. Create a blank spreadsheet if you want

If you don't want to use a spreadsheet template with a built-in format, click “ Blank workbook ” in the top left corner of the page, then go to step seven (heading/heading of data).

Make a Spreadsheet Step 3
Make a Spreadsheet Step 3

Step 3. Explore the available template options

Browse the list of templates in the Excel window or type a word or phrase into the search field at the top of the screen to search for templates by keyword.

Make a Spreadsheet Step 4
Make a Spreadsheet Step 4

Step 4. Choose a template

Click the template you want to use to select it. The template window will open after that.

Make a Spreadsheet Step 5
Make a Spreadsheet Step 5

Step 5. Click Create

It's on the right side of the template window. After that, the template will be opened in Excel.

Make a Spreadsheet Step 6
Make a Spreadsheet Step 6

Step 6. Fill in the form on the template if necessary

If you are using a template with a built-in format, fill in the required form to complete the template, then move on to step 13 (saves sheet).

  • Skip this step if you are not using a template.
  • Some templates use multiple spreadsheets that you can access via the tabs in the lower-left corner of the Excel window.
Make a Spreadsheet Step 7
Make a Spreadsheet Step 7

Step 7. Know where to add the data header/title

Usually you need to put the title or header of the data on the “

Step 1.” above the spreadsheet.

For example, if you are creating a list of employee names and grouping them by department, enter the department name in the “ A1 ”, then the name of another department in the box “ B1", etc.

Make a Spreadsheet Step 8
Make a Spreadsheet Step 8

Step 8. Select the box

Single-click the box to which you want to add data.

For example, if you want to type the word "Date" in the " A1, click the box " A1 ”.

Make a Spreadsheet Step 9
Make a Spreadsheet Step 9

Step 9. Enter data

Type the word, phrase, or chart you want to add into the box.

Make a Spreadsheet Step 10
Make a Spreadsheet Step 10

Step 10. Save the data

Press Enter to save it. The data will be formatted and stored on the grid.

Make a Spreadsheet Step 11
Make a Spreadsheet Step 11

Step 11. Enter any other required data

You can fill in the other boxes on the worksheet as you wish or need.

Make a Spreadsheet Step 12
Make a Spreadsheet Step 12

Step 12. Sum the data values in the boxes

If you want to use a single square to calculate the total value and the closing parenthesis (eg =SUM(A1, B1)).

  • Press Enter.
  • Review the summation results.
  • Make a Spreadsheet Step 13
    Make a Spreadsheet Step 13

    Step 13. Save the file

    Press the shortcut Ctrl+S (Windows) or Command+S (Mac) to open the " Save As " window, then follow these steps:

    • Type in the desired file name.
    • Select a storage location (on Mac computers, you'll need to click the " Where " drop-down box first).
    • Click " Save ”.

    Method 2 of 3: Using Apple Numbers

    Make a Spreadsheet Step 14
    Make a Spreadsheet Step 14

    Step 1. Open

    Macnumbers
    Macnumbers

    Numbers.

    Click or double-click the Numbers app icon, which looks like a series of white horizontal bars on a light green background.

    Make a Spreadsheet Step 15
    Make a Spreadsheet Step 15

    Step 2. Create a blank spreadsheet if you want

    If you want to create a blank spreadsheet, follow these steps and move on to step seven (adding data headers/titles):

    • Click the tab " All ” in the upper-left corner of the Numbers window.
    • Click on “template” Blank ” in the top left corner of the page.
    • Click " Choose ” in the lower right corner of the window.
    Make a Spreadsheet Step 16
    Make a Spreadsheet Step 16

    Step 3. Browse the available template categories

    On the left side of the window, you can see several tabs (eg. All ”, “ Basic , and others). Click a tab to display a list of templates from the selected category.

    You can also browse the list of templates in the middle of the page

    Make a Spreadsheet Step 17
    Make a Spreadsheet Step 17

    Step 4. Select a specific template to use

    Single-click the template you want to use to select it.

    Make a Spreadsheet Step 18
    Make a Spreadsheet Step 18

    Step 5. Click Choose

    It's in the lower-right corner of the window. The template will open in the Numbers window.

    Make a Spreadsheet Step 19
    Make a Spreadsheet Step 19

    Step 6. Fill in the form on the template if necessary

    If you are using a template with a built-in format, fill in the required forms to complete the template, then move on to step 13 (saves sheet).

    • Skip this step if you are not using a template.
    • Some templates use multiple spreadsheets that you can access via the tabs in the lower-left corner of the Numbers window.
    Make a Spreadsheet Step 20
    Make a Spreadsheet Step 20

    Step 7. Know where to add the data header/title

    Usually you need to put the title or header of the data on the “

    Step 1.” above the spreadsheet.

    For example, if you create a list of employee names and group them by department, enter the department name in the “ A1 ”, then the name of another department in the box “ B1", etc.

    Make a Spreadsheet Step 21
    Make a Spreadsheet Step 21

    Step 8. Select the box

    Single-click the box to which you want to add data.

    For example, if you want to type the word "Date" in the " A1, click the box " A1 ”.

    Make a Spreadsheet Step 22
    Make a Spreadsheet Step 22

    Step 9. Enter data

    Type the word, phrase, or chart you want to add into the box.

    Make a Spreadsheet Step 23
    Make a Spreadsheet Step 23

    Step 10. Save the data

    Press Return key to save the data. After that, the data will be formatted and saved to the grid.

    Make a Spreadsheet Step 24
    Make a Spreadsheet Step 24

    Step 11. Enter any other required data

    You can fill in the other boxes on the worksheet as you wish or need.

    Make a Spreadsheet Step 25
    Make a Spreadsheet Step 25

    Step 12. Sum the data values in the boxes

    If you want to use a single square to calculate the total value and the closing parenthesis (eg =SUM(A1, B1)).

  • Press Return.
  • Review the sum of the data values.
  • Make a Spreadsheet Step 26
    Make a Spreadsheet Step 26

    Step 13. Save the spreadsheet

    Once you've finished creating the spreadsheet, you can save it as a file on your computer with these steps:

    • Click " File ” in the upper-left corner of the screen.
    • Click " Save As… ” in the drop-down menu.
    • Enter a file name.
    • Select a storage location (you may need to click the " Where " drop-down box first to see the directory listing).
    • Click " Save ”.

    Method 3 of 3: Using Google Sheets

    Make a Spreadsheet Step 27
    Make a Spreadsheet Step 27

    Step 1. Go to the “About” page of the Google Sheets service

    Visit https://www.google.com/sheets/about/ through your computer's web browser.

    Make a Spreadsheet Step 28
    Make a Spreadsheet Step 28

    Step 2. Click Go to Google Sheets

    It's a blue button at the bottom of the page. After that, the Google Sheets page for your Google account will open.

    If you're not logged into your Google account, type in your email address and password when prompted

    Make a Spreadsheet Step 29
    Make a Spreadsheet Step 29

    Step 3. Show template options if necessary

    If you don't see a list of templates at the top of your Google Sheets page, you can view them with these steps:

    • Click " ” in the top left corner of the page.
    • Click " Settings ”.
    • Check the " Templates " box.
    • Click " OK ”.
    Make a Spreadsheet Step 30
    Make a Spreadsheet Step 30

    Step 4. Create a blank spreadsheet if necessary

    If you want to create a blank worksheet and fill it in while continuing to work, click the “ Blank ” on the left side of the template list, then move on to step eight (adding a header/data title).

    Make a Spreadsheet Step 31
    Make a Spreadsheet Step 31

    Step 5. Expand the list of available templates

    Click the link GALLERY TEMPLATES ” in the top right corner of the page to expand the list.

    Make a Spreadsheet Step 32
    Make a Spreadsheet Step 32

    Step 6. Choose a template

    Browse the list of templates for available options until you find the template you want to use, then click on a template to open it in Google Sheets.

    Make a Spreadsheet Step 33
    Make a Spreadsheet Step 33

    Step 7. Fill out the template form if necessary

    If you are using a template with a built-in format, fill out the required forms to complete the template, then move on to step 14 (download sheet).

    • Skip this step if you are not using a template.
    • Some templates use multiple spreadsheets that you can access via the tabs in the lower-left corner of the page.
    Make a Spreadsheet Step 34
    Make a Spreadsheet Step 34

    Step 8. Identify where to add the data header/title

    Usually you need to put the title or header of the data on the “

    Step 1.” above the spreadsheet.

    For example, if you are creating a list of employee names and grouping them by department, enter the department name in the “ A1 ”, then the name of another department in the box “ B1", etc.

    Make a Spreadsheet Step 35
    Make a Spreadsheet Step 35

    Step 9. Select the box

    Single-click the box to which you want to add data.

    For example, if you want to type the word "Date" in the " A1, click the box " A1 ”.

    Make a Spreadsheet Step 36
    Make a Spreadsheet Step 36

    Step 10. Enter data

    Type the word, phrase, or chart you want to add into the box.

    Make a Spreadsheet Step 37
    Make a Spreadsheet Step 37

    Step 11. Save the data

    Press Enter to save it. The data will be formatted and stored on the grid.

    Make a Spreadsheet Step 38
    Make a Spreadsheet Step 38

    Step 12. Enter any other required data

    You can fill in the other boxes on the worksheet as you wish or need.

    Make a Spreadsheet Step 39
    Make a Spreadsheet Step 39

    Step 13. Sum the data values in the boxes

    If you want to use a single square to calculate the total value and the closing parenthesis (eg =SUM(A1, B1)).

  • Press Enter.
  • Review the summation results.
  • Make a Spreadsheet Step 40
    Make a Spreadsheet Step 40

    Step 14. Download the spreadsheet

    The spreadsheet will be saved to your Google Drive account, but you can download it to your computer as a file with these steps:

    • Click the menu " File ” in the top-left corner of the Google Sheets page.
    • Choose " Download as ” in the drop-down menu.
    • Click the file format in the drop-down menu, e.g. " Microsoft Excel (.xlsx) ”.

    Tips

    • You can usually print a spreadsheet by clicking on the “ File ", choose " Print, and clicked “ Print ” in the “Printers” window.
    • Sheets can be used for a variety of purposes, from managing contacts to creating payroll counters.

    Recommended: