Learning how to create a spreadsheet in Excel starts with opening a blank workbook, adding column headings, and entering your information into rows. You can then use formulas to calculate results, format the data for readability, and save the workbook for future use.
You do not need advanced technical skills to build a useful spreadsheet. A simple sheet can help you track expenses, manage stock, organize assignments, or record sales.
This guide walks through the process using a small expense tracker. You can follow the same structure for many other tasks.
Version note: The instructions mainly follow desktop Excel. Menu wording and button locations may differ slightly between Windows, Mac, and Excel for the web.
Understand the Basic Parts of Excel
Before entering information, it helps to understand a few terms.
| Term | Meaning |
|---|---|
| Workbook | The Excel file containing your worksheets |
| Worksheet | An individual sheet inside the workbook |
| Column | A vertical group of cells, usually labeled with letters |
| Row | A horizontal group of cells labeled with numbers |
| Cell | The intersection of a row and column |
| Cell reference | A cell’s address, such as A1 or D5 |
| Range | A group of cells, such as A1:D6 |
| Formula | An instruction Excel uses to calculate a result |
For example, B3 means the cell in column B and row 3. The range B2:B6 includes cells B2 through B6.
Understanding these addresses makes it easier to follow formulas and select the correct information.
1. Decide What Your Spreadsheet Should Do
The first step in learning how to create a spreadsheet in Excel is deciding what you want to organize.
Write one clear purpose before opening the workbook.
Examples include:
- Tracking monthly expenses.
- Recording products and quantities.
- Managing a list of assignments.
- Comparing planned and actual spending.
- Recording orders and payments.
For this tutorial, the goal is to record five expenses and calculate their total.
Choose One Record Per Row
Each row should represent one item, transaction, or event.
For an expense tracker, one row represents one expense. For an inventory list, one row might represent one product.
Give Each Column One Purpose
Keep different types of information in separate columns.
Instead of entering “Groceries 85” in a single cell, place “Groceries” under an item heading and 85 under an amount heading.
This makes the information easier to sort, filter, and calculate.
2. Open Excel and Create a Blank Workbook
Open Microsoft Excel and select Blank workbook.
If another workbook is already open, use File → New and choose a blank workbook.
You will see a grid of empty cells. Click A1, the cell at the intersection of column A and row 1.
That is where the example spreadsheet will begin.
Blank Workbook or Template?
A blank workbook gives you control over the layout. A template provides an existing structure that you can adapt.
For your first attempt, starting with a blank workbook helps you understand how the parts fit together.
Once you know how to create a spreadsheet in Excel, templates can save time when you need a familiar layout repeatedly.
3. Add Clear Column Headings
Enter these headings in row 1:
| Cell | Heading |
|---|---|
| A1 | Date |
| B1 | Item |
| C1 | Category |
| D1 | Amount |
Click A1, type Date, and press Tab to move to B1. Continue until all four headings are entered.
Pressing Enter normally confirms an entry and moves down, while Tab moves across.
Keep Headings Short and Specific
“Amount” is clearer than “Information.” “Payment Date” is more useful than “Details.”
If the numbers represent a specific currency, you can use a heading such as Amount (USD).
Avoid Merged Cells in the Data Area
For a simple list, keep one heading in each cell.
Merged cells can make sorting and selecting data less convenient. A straightforward rectangular layout is easier to maintain as the sheet grows.
4. Enter Your Data Into Rows
Starting in row 2, enter the following fictional expenses:
| Date | Item | Category | Amount |
|---|---|---|---|
| 1 Oct 2026 | Groceries | Food | 85 |
| 2 Oct 2026 | Bus pass | Transport | 30 |
| 3 Oct 2026 | Internet | Utilities | 50 |
| 4 Oct 2026 | Notebooks | Education | 15 |
| 5 Oct 2026 | Lunch | Food | 20 |
The data occupies A1:D6, including the headings.
These figures are examples for practice.
Enter Amounts as Numbers
Type 85 rather than 85 dollars in D2.
Keeping the amount numeric allows Excel to calculate it. You can display a currency symbol through formatting later.
Use Consistent Categories
Choose one category label and use it consistently.
For example, avoid mixing “Transport,” “Transportation,” and “Travel” when you intend them to mean the same thing.
Keep Records Together
Avoid inserting blank rows between every expense. A continuous block of records is easier to manage.
Good data entry habits are a central part of how to create a spreadsheet in Excel that remains useful after the first few rows.
5. Format Dates, Numbers, and Headings
Formatting helps readers understand the sheet without changing the meaning of the information.
Select A1:D1 and apply bold text. Add a simple fill color if you want the headings to stand out.
Then select the amount cells, D2:D6, and choose Currency or Accounting from the number-format options on the Home tab.
Choose the appropriate currency symbol rather than assuming the default matches your needs.
Adjust Column Widths
If a heading or item name is cut off, widen the column.
You can drag the boundary between column letters. In desktop Excel, double-clicking the boundary can automatically fit the column to its contents.
Format Dates Consistently
Select A2:A6 and apply a date format.
Using a format that shows the month name can reduce confusion between day-first and month-first conventions.
Understand What Formatting Changes
Number formatting changes how a value appears.
For example, a stored value of 85 can display as $85.00. The underlying value remains numeric.
When learning how to create a spreadsheet in Excel, keep the entered value and its display format separate in your thinking.
6. Add Formulas and Calculate a Total
Formulas begin with an equals sign.
To total the five expenses, type Total in C8. Then click D8 and enter:
=SUM(D2:D6)Press Enter.
The result should be 200.
The formula adds the numeric values in cells D2 through D6.
Use AutoSum
You can also select D8 and choose AutoSum from the Home or Formulas tab.
Check the proposed range before confirming. Because this example leaves row 7 blank, Excel may need you to select D2:D6 manually.
Try Other Calculations
Use separate cells below the total if you want to explore these formulas:
| Calculation | Formula | Expected result |
|---|---|---|
| Average expense | =AVERAGE(D2:D6) | 40 |
| Largest expense | =MAX(D2:D6) | 85 |
| Smallest expense | =MIN(D2:D6) | 15 |
| Number of numeric entries | =COUNT(D2:D6) | 5 |
Your Excel language settings may use localized function names.
Formulas are what turn a basic list into a working tool. They are an important next step in understanding how to create a spreadsheet in Excel.
7. Turn Your Data Into an Excel Table
An Excel table adds structure to your records.
Select A1:D6, including the headings, and choose Insert → Table.
Confirm the range and select My table has headers. Then choose OK.
Keep the separate summary cells below the data outside this selection.
Why Use a Table?
Tables provide a consistent style and convenient controls for working with a list. Header filters help you narrow down the records you want to see.
Choose a simple table style that keeps the text readable.
Add More Records Carefully
As you add expenses, check that the new rows become part of the table.
Also review any summary formulas outside it. The earlier formula =SUM(D2:D6) refers to a specific range, so confirm that it includes new entries.
Learning how to create a spreadsheet in Excel also means checking that your calculations continue to cover your growing data.
8. Sort, Filter, and Keep Headings Visible
Sorting changes the order of records. Filtering temporarily hides records that do not match your selection.
Sort the Largest Expenses First
Use the Amount header’s menu and choose the descending numerical sort option.
The groceries expense should appear above the smaller expenses.
Keep the whole record together when sorting. Sorting only one disconnected column could separate amounts from their corresponding items.
Filter by Category
Open the Category filter and select Food.
For the sample data, Groceries and Lunch should remain visible. Clear the filter to show all records again.
Remember that hiding rows with a filter does not automatically make every formula calculate only visible rows. The basic SUM formula still includes its referenced values.
Freeze the Header Row
To keep row 1 visible while scrolling in desktop Excel, choose:
View → Freeze Panes → Freeze Top Row
This becomes useful when a worksheet contains many records.
These tools make how to create a spreadsheet in Excel relevant to larger lists, not just small practice examples.
9. Create a Simple Chart
A chart can make comparisons easier to understand.
For this example, select B1:B6, including the Item heading. Then select the corresponding Amount range, D1:D6, as an additional selection.
In desktop Excel, use Ctrl on Windows or Command on Mac when selecting separate ranges.
Choose Insert and select a column or bar chart. You can also explore Recommended Charts where available.
Give the Chart a Clear Title
Replace a generic title with something descriptive, such as:
Expenses by Item
Check that item names appear as labels and amounts appear as values.
Match the Chart to the Question
A bar or column chart works well for comparing the five example expenses.
A line chart is better suited to showing change over time when the data supports that comparison.
Before sharing, check that the chart represents the intended cells and does not include the separate total as another expense.
10. Save and Check Your Workbook
Saving completes the basic process of how to create a spreadsheet in Excel.
On desktop Excel, choose File → Save As, select a location, and give the workbook a descriptive name.
For example:
October_Expense_Tracker.xlsxUse Excel Workbook (.xlsx) for this ordinary workbook.
On Windows, Ctrl+S saves subsequent changes. On Mac, use Command+S.
Understand Browser Saving
Excel for the web saves changes to the workbook’s online location. Check the filename and saving status before closing the browser.
Download a copy if you also need a local file.
Perform a Quick Accuracy Check
Before considering the sheet finished:
- Confirm that all five sample expenses are entered.
- Check that the total is 200.
- Review the dates and categories.
- Make sure the file is saved where expected.
- Confirm that the chart uses the correct data.
A neat appearance is helpful, but correct information matters more.
Common Beginner Mistakes
Small errors can affect calculations or make a worksheet harder to maintain.
Mixing Numbers With Words
Entering “50 dollars” instead of a numeric amount can prevent the cell from behaving as expected in calculations.
Keep units in headings or use number formatting.
Replacing a Formula With a Value
Typing over a formula removes the calculation from that cell.
Before editing a result, check the formula bar to see whether it contains a formula.
Ignoring the Formula Range
When new records are added, verify that totals include them.
A formula can be mathematically correct while still referring to an incomplete range.
Misreading Percentage Formatting
The numeric value 0.25 displays as 25% when percentage formatting is applied. Formatting the existing value 25 as a percentage displays 2500%.
Leaving Unclear Headings
Someone opening your workbook later should understand what each column represents.
These habits help you move beyond learning how to create a spreadsheet in Excel and toward building reliable worksheets.
Frequently Asked Questions
How do I create a spreadsheet in Excel from scratch?
Open a blank workbook, add headings, enter one record per row, format your data, add any needed formulas, and save the workbook.
What is the difference between a workbook and a worksheet?
A workbook is the Excel file. A worksheet is an individual sheet inside that file.
Do I need formulas?
No. A list can be useful without formulas. Add them when you need calculations such as totals, averages, or comparisons.
Can I create a spreadsheet in a browser?
Yes. Excel for the web allows you to create and edit workbooks in a browser. Some controls and features differ from desktop Excel.
Why does a cell show hash marks?
A cell displaying ##### may be too narrow for its formatted value. Try widening the column first.
Should I save as XLSX or CSV?
Use XLSX when you need to preserve workbook features such as multiple worksheets, formatting, and charts. CSV is suited to exchanging a single sheet’s plain data and does not preserve those workbook features.
How can I practice?
Create the example expense tracker, confirm the total, and then add another expense. Check how the table, formulas, and chart respond.
Build a Spreadsheet You Can Keep Using
Understanding how to create a spreadsheet in Excel comes down to a few dependable habits: use clear headings, keep records consistent, calculate with the correct cells, and save your work.
Start with a small sheet that solves one problem. Once the structure works, add tables, filters, and charts when they make the information easier to use.
About the Author
