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
-
How to Make a Spreadsheet Picture 1
Open Microsoft Excel. Click or double-click the Excel app icon, which resembles a white "X" on a dark-green background. -
How to Make a Spreadsheet Picture 2
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. -
How to Make a Spreadsheet Picture 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. -
How to Make a Spreadsheet Picture 4
Select a template. Click the template you want to use to do so. The template's window will open. -
How to Make a Spreadsheet Picture 5
Click Create. It's on the right side of the template window. Doing so opens the template in Excel. -
How to Make a Spreadsheet Picture 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.
-
How to Make a Spreadsheet Picture 7
Know where to place your data headers. You'll usually place headers in the 1 row 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 cell A1 and another in cell B1, etc.
-
How to Make a Spreadsheet Picture 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 cell A1, you would click cell A1.
-
How to Make a Spreadsheet Picture 9
Enter your data. Type in the word, phrase, or figure that you want to enter into the cell. -
How to Make a Spreadsheet Picture 10
Save the data. Press ↵ Enter to do so. Your cell's data will be formatted and saved. -
How to Make a Spreadsheet Picture 11
Enter any other necessary data. You can fill out the rest of your spreadsheet as you please. -
How to Make a Spreadsheet Picture 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)).
- Press ↵ Enter.
- Review the sum.
-
How to Make a Spreadsheet Picture 13
Save your file. Press either Ctrl+S (Windows) or ⌘ Command+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).
- Click Save.
Method 2 of 3:
Using Apple Numbers
-
How to Make a Spreadsheet Picture 14
OpenHow to Make a Spreadsheet Picture 15
-
How to Make a Spreadsheet Picture 16
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 the All tab in the upper-left side of the Numbers window.
- Click the Blank template in the upper-left corner of the page.
- Click Choose in the lower-right side of the window.
-
How to Make a Spreadsheet Picture 17
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.
-
How to Make a Spreadsheet Picture 18
Select a specific template to use. Click once the template you want to use to select it. -
How to Make a Spreadsheet Picture 19
Click Choose. It's in the lower-right corner of the window. Your template will open in Numbers. -
How to Make a Spreadsheet Picture 20
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.
-
How to Make a Spreadsheet Picture 21
Know where to place your data headers. You'll usually place headers in the 1 row 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 cell A1 and another in cell B1, etc.
-
How to Make a Spreadsheet Picture 22
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 cell A1, you would click cell A1.
-
How to Make a Spreadsheet Picture 23
Enter your data. Type in the word, phrase, or figure that you want to enter into the cell. -
How to Make a Spreadsheet Picture 24
Save the data. Press ⏎ Return to do so. Your cell's data will be formatted and saved. -
How to Make a Spreadsheet Picture 25
Enter any other necessary data. You can fill out the rest of your spreadsheet as you please. -
How to Make a Spreadsheet Picture 26
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)).
- Press ⏎ Return.
- Review the sum.
-
How to Make a Spreadsheet Picture 27
Save your spreadsheet. Once you've finished creating the spreadsheet, you can save it as a file on your computer by doing the following:- Click File in the upper-left corner of the screen.
- Click Save 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).
- Click Save.
Method 3 of 3:
Using Google Sheets
-
How to Make a Spreadsheet Picture 28
Open the Google Sheets About page. Go to https://www.google.com/sheets/about/ in your computer's web browser. -
How to Make a Spreadsheet Picture 29
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.- If you aren't logged into a Google Account, you'll need to enter your email address and password when prompted.
-
How to Make a Spreadsheet Picture 30
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:- Click ☰ in the top-left side of the page.
- Click Settings.
- Check the "Templates" box.
- Click OK.
-
How to Make a Spreadsheet Picture 31
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. -
How to Make a Spreadsheet Picture 32
Expand the list of available templates. Click the TEMPLATE GALLERY link in the upper-right side of the page to do so. -
How to Make a Spreadsheet Picture 33
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. -
How to Make a Spreadsheet Picture 34
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.
-
How to Make a Spreadsheet Picture 35
Know where to place your data headers. You'll usually place headers in the 1 row 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 cell A1 and another in cell B1, etc.
-
How to Make a Spreadsheet Picture 36
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 cell A1, you would click cell A1.
-
How to Make a Spreadsheet Picture 37
Enter your data. Type in the word, phrase, or figure that you want to enter into the cell. -
How to Make a Spreadsheet Picture 38
Save the data. Press ↵ Enter to do so. Your cell's data will be formatted and saved. -
How to Make a Spreadsheet Picture 39
Enter any other necessary data. You can fill out the rest of your spreadsheet as you please. -
How to Make a Spreadsheet Picture 40
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)).
- Press ↵ Enter.
- Review the sum.
-
How to Make a Spreadsheet Picture 41
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:- Click File in the upper-left side of the Google Sheets page.
- Select Download as in the drop-down menu.
- Click a file format (e.g., Microsoft Excel (.xlsx)) in the drop-down menu.
Sample Spreadsheets
![How to Make a Spreadsheet Picture 42](https://tipsmake.com/data/images/how-to-make-a-spreadsheet-picture-42-rB1m4o7sb.png)
![How to Make a Spreadsheet Picture 43](https://tipsmake.com/data/images/how-to-make-a-spreadsheet-picture-43-KBCJ9fvLh.png)
![How to Make a Spreadsheet Picture 44](https://tipsmake.com/data/images/how-to-make-a-spreadsheet-picture-44-6ANwiqsFz.png)
4 ★ | 1 Vote
You should read it
- MS PowerPoint - Lesson 7: PowerPoint design template
- 10 awesome PowerPoint templates make the presentation 'shine'
- Template in C ++
- Diagonal lines in a cell in Excel
- How to Round in Excel
- How to name, comment and protect cells in Excel
- The best free Microsoft Word template download websites
- Lesson 25: Use the Template
- Invite download Profile template Curriculum vitae, job application, ... extremely professional from Microsoft
- Top gorgeous Word cover templates for books, reports, lesson plans
- Create slides from a template available in PowerPoint
- MS PowerPoint - Lesson 4: PowerPoint design template