You are viewing the article How to Make a Spreadsheet in Excel at Tnhelearning.edu.vn you can quickly access the necessary information in the table of contents of the article below.
X
wikiHow is a “wiki” site, which means that many of the articles here are written by multiple authors. To create this article, 57 people, some of whom are anonymous, have edited and improved the article over time.
This article has been viewed 28,504 times.
Spreadsheets are a great tool to help you sum many different things. This article shows you how to create a basic spreadsheet in Microsoft Excel as a simple expense report.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/b/ba/Make-a-Spreadsheet-in-Excel-Step-1-Version-4.jpg/v4-728px-Make- a-Spreadsheet-in-Excel-Step-1-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/b/ba/Make-a-Spreadsheet-in- Excel-Step-1-Version-4.jpg/v4-728px-Make-a-Spreadsheet-in-Excel-Step-1-Version-4.jpg”,”smallWidth”:460,”smallHeight”:345,” bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Open Excel.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/9/92/Make-a-Spreadsheet-in-Excel-Step-2-Version-4.jpg/v4-728px-Make- a-Spreadsheet-in-Excel-Step-2-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/9/92/Make-a-Spreadsheet-in- Excel-Step-2-Version-4.jpg/v4-728px-Make-a-Spreadsheet-in-Excel-Step-2-Version-4.jpg”,”smallWidth”:460,”smallHeight”:345,” bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Note that there are many rows and many columns.
- Each column has a capital letter at the top so you know which column it is.
- Each row has a number right to the left of the first column so you know which row it is.
- The position of each cell is identified by the column letter followed by the row number. Example: The position of the cell is in the first column, the first row is A1. The position of the cell is in the second column, the third row is B3.
- If you click on a cell, its location will appear directly above column A.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/e/eb/Make-a-Spreadsheet-in-Excel-Step-3-Version-4.jpg/v4-728px-Make- a-Spreadsheet-in-Excel-Step-3-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/e/eb/Make-a-Spreadsheet-in- Excel-Step-3-Version-4.jpg/v4-728px-Make-a-Spreadsheet-in-Excel-Step-3-Version-4.jpg”,”smallWidth”:460,”smallHeight”:345,” bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Click cell A1 and then type: Item.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/0/0c/Make-a-Spreadsheet-in-Excel-Step-4-Version-4.jpg/v4-728px-Make- a-Spreadsheet-in-Excel-Step-4-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/0/0c/Make-a-Spreadsheet-in- Excel-Step-4-Version-4.jpg/v4-728px-Make-a-Spreadsheet-in-Excel-Step-4-Version-4.jpg”,”smallWidth”:460,”smallHeight”:345,” bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Click cell B1 and then type: Cost.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/5/54/Make-a-Spreadsheet-in-Excel-Step-5-Version-4.jpg/v4-728px-Make- a-Spreadsheet-in-Excel-Step-5-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/5/54/Make-a-Spreadsheet-in- Excel-Step-5-Version-4.jpg/v4-728px-Make-a-Spreadsheet-in-Excel-Step-5-Version-4.jpg”,”smallWidth”:460,”smallHeight”:345,” bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Click cell A2 and then type: Printing.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/6/6e/Make-a-Spreadsheet-in-Excel-Step-6-Version-4.jpg/v4-728px-Make- a-Spreadsheet-in-Excel-Step-6-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/6/6e/Make-a-Spreadsheet-in- Excel-Step-6-Version-4.jpg/v4-728px-Make-a-Spreadsheet-in-Excel-Step-6-Version-4.jpg”,”smallWidth”:460,”smallHeight”:345,” bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Click cell B2 and then type 80.00.
- After clicking outside cell B2, the number 80 will appear in cell B2.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/7/7b/Make-a-Spreadsheet-in-Excel-Step-7-Version-4.jpg/v4-728px-Make- a-Spreadsheet-in-Excel-Step-7-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/7/7b/Make-a-Spreadsheet-in- Excel-Step-7-Version-4.jpg/v4-728px-Make-a-Spreadsheet-in-Excel-Step-7-Version-4.jpg”,”smallWidth”:460,”smallHeight”:345,” bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Click cell A3 and then type: Postage.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/8/8c/Make-a-Spreadsheet-in-Excel-Step-8-Version-4.jpg/v4-728px-Make- a-Spreadsheet-in-Excel-Step-8-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/8/8c/Make-a-Spreadsheet-in- Excel-Step-8-Version-4.jpg/v4-728px-Make-a-Spreadsheet-in-Excel-Step-8-Version-4.jpg”,”smallWidth”:460,”smallHeight”:345,” bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Click cell B3 and then type: 75.55.
- After clicking outside cell B3, the number 75.55 will appear in cell B3.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/0/06/Make-a-Spreadsheet-in-Excel-Step-9-Version-4.jpg/v4-728px-Make- a-Spreadsheet-in-Excel-Step-9-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/0/06/Make-a-Spreadsheet-in- Excel-Step-9-Version-4.jpg/v4-728px-Make-a-Spreadsheet-in-Excel-Step-9-Version-4.jpg”,”smallWidth”:460,”smallHeight”:345,” bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Click cell A4 and then type: Envelopes.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/f/f8/Make-a-Spreadsheet-in-Excel-Step-10-Version-4.jpg/v4-728px-Make- a-Spreadsheet-in-Excel-Step-10-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/f/f8/Make-a-Spreadsheet-in- Excel-Step-10-Version-4.jpg/v4-728px-Make-a-Spreadsheet-in-Excel-Step-10-Version-4.jpg”,”smallWidth”:460,”smallHeight”:345,” bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Click cell B4 and then type: 6.00.
- After clicking outside cell B4, the number 6 will appear in cell B4.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/6/61/Make-a-Spreadsheet-in-Excel-Step-11-Version-4.jpg/v4-728px-Make- a-Spreadsheet-in-Excel-Step-11-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/6/61/Make-a-Spreadsheet-in- Excel-Step-11-Version-4.jpg/v4-728px-Make-a-Spreadsheet-in-Excel-Step-11-Version-4.jpg”,”smallWidth”:460,”smallHeight”:345,” bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Click cell A5 and then type: Total.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/7/7b/Make-a-Spreadsheet-in-Excel-Step-12-Version-4.jpg/v4-728px-Make- a-Spreadsheet-in-Excel-Step-12-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/7/7b/Make-a-Spreadsheet-in- Excel-Step-12-Version-4.jpg/v4-728px-Make-a-Spreadsheet-in-Excel-Step-12-Version-4.jpg”,”smallWidth”:460,”smallHeight”:345,” bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Click cell B5 and then type: =SUM(B2:B4).
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/f/f8/Make-a-Spreadsheet-in-Excel-Step-13-Version-4.jpg/v4-728px-Make- a-Spreadsheet-in-Excel-Step-13-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/f/f8/Make-a-Spreadsheet-in- Excel-Step-13-Version-4.jpg/v4-728px-Make-a-Spreadsheet-in-Excel-Step-13-Version-4.jpg”,”smallWidth”:460,”smallHeight”:345,” bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Click another cell. The sum of 161.55 will appear in cell B5.
- SUM(B2:B4) is a calculation formula. This formula is used to perform mathematical calculations in Excel. You must type an equal sign (=) in front of the formula so that Excel knows that it is a calculation formula.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/a/af/Make-a-Spreadsheet-in-Excel-Step-14-Version-4.jpg/v4-728px-Make- a-Spreadsheet-in-Excel-Step-14-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/a/af/Make-a-Spreadsheet-in- Excel-Step-14-Version-4.jpg/v4-728px-Make-a-Spreadsheet-in-Excel-Step-14-Version-4.jpg”,”smallWidth”:460,”smallHeight”:345,” bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Click Save .
Advice
- The above method can be applied with Excel 2003 or earlier versions of Excel.
- Select cells from B2 to B4.
Things you need
- Computer running Windows/Mac OSX
- Microsoft Excel
X
wikiHow is a “wiki” site, which means that many of the articles here are written by multiple authors. To create this article, 57 people, some of whom are anonymous, have edited and improved the article over time.
This article has been viewed 28,504 times.
Spreadsheets are a great tool to help you sum many different things. This article shows how to create a basic spreadsheet in Microsoft Excel as a simple expense report.
Thank you for reading this post How to Make a Spreadsheet in Excel at Tnhelearning.edu.vn You can comment, see more related articles below and hope to help you with interesting information.
Related Search: