You create a spreadsheet in Excel by opening the app, choosing Blank workbook, entering labels and values into cells, and saving the file as .xlsx. On Windows 11 with Microsoft 365, that means clicking Start, typing "Excel," pressing Enter, and picking Blank workbook on the start screen — a path that takes about 15 seconds on a typical machine. The steps differ inside the browser version, so the section on Excel for the web covers that variant separately. Everything below is written for Microsoft 365 Excel on Windows, with notes where Excel 2019, 2021, and 2024 behave the same.

Open Excel and Pick the Right Blank Template

Every new file begins on Excel's start screen, which shows a Blank workbook tile in the top-left corner of the template gallery. Click it once and Excel drops you into a fresh grid named "Book1" until you save. If the start screen doesn't appear on launch, go to File > New and click Blank workbook there instead.

Beneath the blank tile sit built-in templates like Budget, Invoice, and Monthly budget. Templates pre-fill formulas you then overwrite, which saves typing but hides the formula logic from a beginner. For a first spreadsheet, the blank grid teaches more in the same amount of time.

Keyboard-shortcut users can press Ctrl+N from inside Excel to spin up a new blank workbook without touching the mouse. On a Mac, it's Command+N. Either way, the new file lands in the same grid.

One version difference matters here. Excel 2019 and 2021 for Windows open to the start screen the same way, but the desktop app's template search bar only appears when you're signed into a Microsoft account. Without a sign-in, the gallery still shows the blank tile, so you can proceed. Excel for the web shows New blank workbook as a button on the OneDrive homepage.

Fill the Header Row Like a Label, Not a Sentence

Type the first column label into cell A1 and press Tab to move right; Tab keeps you in the same row, which is exactly what headers need. A monthly expense sheet typically reads Date, Item, Category, Amount, and Notes across A1 through E1. Press Enter at the end of the row to drop to the next line.

Keep headers to one or two words. A header is a column name, not a caption: Category beats "What kind of thing was this purchase." Short labels make formulas easier to write later because Excel's autocomplete needs the exact name.

Capitalize the first letter of every header. Mixed casing looks sloppy when you sort or filter a table, and Excel's Format as Table feature copies header text into filter dropdowns verbatim.

If you want a quick visual cue for header text, select row 1 and press Ctrl+B for bold. That's a formatting choice, not a required step — Excel doesn't care whether headers are bold, colored, or plain.

Enter Data in Real Performance Order with Tab, Enter, and Arrow Keys

Fill row 2 with your first real record: type the date in A2, the item in B2, the category in C2, and the amount in D2. Use Tab between cells, then Enter when the row is done. Excel returns the cursor to column A of the next row, which keeps data entry fast and consistent.

Enter amounts as bare numbers: type 42.50, not $42.50. Excel applies currency formatting separately, and a symbol typed into the cell can turn the value into text that won't sum. If a cell already shows a green triangle in the corner, Excel suspects a number is stored as text — click the cell, then the warning icon, and choose Convert to Number.

Dates follow the same rule. Type 11/12/2026 and Excel reads it as a date; type Nov 12 and it guesses the current year, which is usually 2026 but occasionally 2025 if your system clock is off by a day near New Year. For budgets and schedules, type the full four-digit year to avoid ambiguity.

Press Ctrl+Z the moment a keystroke goes wrong. Excel's undo stack in Microsoft 365 holds up to 100 actions, though older versions hold fewer — Excel 2010 keeps 100 as well, but some add-ins trim the stack.

Turn the Range Into a Table with Ctrl+T

Select any cell inside your data and press Ctrl+T. Excel pops a dialog asking whether the range has headers; confirm My table has headers and click OK. The range converts to an Excel Table with banded row colors, filter arrows on every header, and a structured name like Table1 in the Name Box.

The Ctrl+T shortcut changes practical behavior in three ways. Filters appear automatically, so you can slice your expenses by Category in two clicks. Formulas written in one cell auto-fill down the column. And new rows typed directly beneath the table inherit formatting and formulas — a small but real time saver.

A table also protects against one of the most common beginner errors: referencing a partial range. If you sum only D2:D15 but later type a new expense in D16, a plain =SUM(D2:D15) misses it. With a table, the formula =SUM(Table1[Amount]) picks up every row, including future ones.

Tables aren't mandatory. A plain formatted range works if you plan to sort manually or copy data elsewhere. Use a table when you'll add rows over time.

Write Two Formulas That Do the Arithmetic For You

Click the empty cell below your Amount column, type =SUM(, then drag from the first amount cell to the last, close the parenthesis, and press Enter. Excel totals the column. The equals sign is the trigger — every formula starts with one, and without it you're just typing text.

For a quick average, type =AVERAGE(D2:D20), replacing the range with your own. Excel ignores blank cells when computing an average, so an empty row drags averages more than it should if you were expecting zeros to count.

A tax example shows why formulas beat hand math. If column D holds subtotals and you want an 8.25% tax column in E, click E2, type =D2*0.0825, and press Tab. Then copy that cell down by dragging the small square handle in the corner (the fill handle) — Excel adjusts D2 to D3, D4, and so on automatically.

If a formula shows #NAME?, Excel doesn't recognize the function name — check for a typo like =SUMM(D2:D20). If it shows #####, the column is too narrow; double-click the boundary between column letters to auto-fit.

Format Numbers, Dates, and Headers So the Sheet Reads Itself

Select the amount column by clicking the D header, then press Ctrl+1 to open the Format Cells dialog. Choose Currency, pick your symbol, and set two decimals. The numbers stay numeric — Excel just displays them with the symbol, keeping totals accurate.

For dates, select column A and use the same Ctrl+1 dialog, then choose a format like Short Date (MM/DD/YYYY in US English, DD/MM/YYYY in UK English). Locale settings control which Excel offers first, so a workbook built in London may show day-first dates when opened in New York unless the format is pinned.

Header styling via Home > Cell Styles > Heading 1 applies Excel's standard bold, colored fill in one click. Avoid manually coloring individual cells row by row; conditional formatting in the same Home tab does that automatically once you define rules like "highlight cells greater than 500."

Column width uses Home > Format > AutoFit Column Width, which sizes every selected column to its longest entry. For a long Notes column, that shortcut can leave a column three inches wide — drag the boundary manually instead if reading width matters more than compactness.

Save Early as .xlsx, Choose OneDrive or Local, and Verify the File Type

Press Ctrl+S on a new workbook and Excel's Save dialog appears. Pick a folder, type a name like November Budget, and leave the type as Excel Workbook (*.xlsx). That extension holds every current feature. Choosing Excel 97-2003 Workbook (*.xls) strips newer features like XLOOKUP and dynamic arrays, so pick it only if someone on your team runs a 2003-era system.

If you're signed into Microsoft 365, the default save location is OneDrive, which enables AutoSave at the top-left toggle. With AutoSave on, every keystroke saves to the cloud within seconds and Version History (File > Info > Version History) lets you roll back to earlier states. AutoSave requires a OneDrive or SharePoint location — it silently greys out when you save to a local folder like C:\Users\name\Documents.

If you save locally, press Ctrl+S at intervals and turn on AutoRecover (which is on by default in Excel 2016 and later) to protect against crashes. AutoRecover isn't the same as a manual save; it saves temporary copies every 10 minutes by default.

Verify the file type after saving by looking at the title bar — Excel shows the filename with the .xlsx extension at the top of the window. If it says "Compatibility Mode," you saved as .xls, and some features are hidden. Use File > Info > Convert to upgrade back to .xlsx.

Create the Same Spreadsheet in Excel for the Web — With Two Real Limitations

Excel for the web opens at office.com in a browser, shows New blank workbook on the OneDrive dashboard, and offers the same grid with the same tabs across the ribbon. Basic entry, SUM, formatting, and Ctrl+S (which saves automatically) all work. If you work on a Chromebook or a locked-down work laptop, this is your fastest path.

The web version does drop two things worth knowing. First, some advanced features — Power Pivot, certain data types, and full VBA macros — don't run in the browser; you'll see a "Open in Desktop App" banner when a file uses them. Second, AutoSave is always on in the web version, which can be a problem if you were hoping to experiment and discard. There's no "Don't save" option on close.

The web version also lacks the offline Ctrl+N shortcut. Building a new file with no internet requires the desktop app or an already-open browser tab.

For the majority of simple spreadsheets — budgets, rosters, checklists — the web version creates the same .xlsx file, opens in the desktop app, and syncs fine. The limitation only bites when you need macros or heavy data modeling.

Copy Data From Word or the Web Without Wrecking the Grid

Highlight the source data in Word or a browser page, press Ctrl+C, then click cell A1 in Excel and press Ctrl+V. Excel drops the content into cells, and if you're pasting from a clean table it usually splits into columns correctly. If it all lands in column A as one blob, that's a text-paste problem, not a bug.

Use Paste Special (Ctrl+Alt+V) when the source carries formatting you don't want. Choose Values to paste only the text and numbers, dropping the bold and colors. Choose Text to strip every trace of formatting. The dialog also has a Transpose option if you want a row to become a column.

Watch for hidden extra spaces in pasted text. A pasted "42.50 " (with a trailing space) may register as text rather than a number, quietly ruining totals. Clean it with Ctrl+H (Find and Replace), searching for a single space and replacing with nothing — but only on cells you know are text, or you'll delete spaces inside names.

For data from a PDF, pasting is often unreliable; Excel's Data > Get Data > From File route handles CSV and Excel files more cleanly than copy-paste, and the Power Query editor lets you fix stray columns before loading them into the sheet.

Add One Chart When a Picture Explains Faster Than the Numbers

Select your Category and Amount columns (hold Ctrl to select non-adjacent ranges), then go to Insert > Recommended Charts and click Clustered Column. Excel generates a chart of your expenses by category with legend, axis, and labels in place, and you can drag it onto any area of the sheet.

Chart selection follows the shape of your data. Categories compared side by side want a bar or column chart. Trends over time want a line chart. Proportions of a whole want a pie chart, though pie charts rarely read well with more than five slices. A spreadsheet of two dozen expense categories with a pie chart becomes unreadable; a bar chart is the better fit.

Chart formatting tweaks — font size, colors, a title — live on the Chart Design and Format tabs that appear when the chart is selected. A default chart title says "Amount" and can be replaced with a real title like November Spending by Category by clicking the text field.

Move the chart to its own sheet via Chart Design > Move Chart > New sheet if you want a dashboard-style page separate from the data. The chart stays linked to the data table, so editing a value updates the visual automatically.

The Beginner Mistakes That Cost Time Later

Two habits hurt novices more than anything else. Typing the $ sign and commas into numbers by hand turns values into text that won't sum — formatting handles the symbols. And storing dates as text like "November 12" forces Excel to guess the year and prevents any date math.

Merged cells break sorting and filtering. Excel will refuse to sort a range with merged cells and shows an error like "This operation requires the merged cells to be identically sized." Use Center Across Selection (Format Cells > Alignment > Horizontal > Center Across Selection) if you want the look of a merged header without the consequence.

A blank-row trap catches people who calculate over a range. If D2:D30 contains blanks, =AVERAGE(D2:D30) divides by the count of non-blank cells, not 29, so the average rises unintentionally. Either fill every cell or use =AVERAGEIF(D2:D30,">0") to skip blanks explicitly.

Finally, an old-workbook trap. Opening an .xls file from a colleague triggers Compatibility Mode, and some newer functions simply aren't available for editing. Convert to .xlsx File > Info > Convert to unlock them, and save a copy under a new name first in case the colleague still needs the old format.

FAQ

What's the fastest way to create a spreadsheet in Excel from scratch?

Press Ctrl+N inside Excel for a new blank workbook, type headers with Tab between columns, and press Ctrl+S to save. That path takes under 30 seconds on Microsoft 365. If Excel isn't already open, launching the app and clicking Blank workbook adds roughly 10 seconds.

Why does my Excel formula show ##### instead of a total?

The ##### display means the column is too narrow for the number, not that the formula failed. Double-click the boundary between the column headers (say between D and E) to auto-fit width. If a formula itself is broken, it shows #VALUE! or #NAME? instead.

Can I create a spreadsheet on my phone?

Yes — the Excel mobile app for iOS and Android (free with a Microsoft account) supports blank workbooks, entry, and most formulas, though ribbon options are condensed. Files save automatically to OneDrive. Complex charts and Power Query are desktop-only features, so plan heavy work there.

Is Excel for the web free, or do I need a subscription?

Excel for the web is free with a Microsoft account at office.com. The free version creates and edits .xlsx files with a somewhat reduced feature set — no macros, no Power Pivot. Desktop Excel requires a Microsoft 365 subscription or a one-time license for Excel 2019/2021/2024.

How is a spreadsheet different from a Word table?

A spreadsheet calculates; a Word table displays. Type =SUM(D2:D10) in an Excel cell and it totals ten cells automatically as you edit them. Word's table can hold numbers but cannot sum them without a field formula that doesn't update the same way.

Why does my sum miss the last row I typed?

Plain range sums like =SUM(D2:D20) freeze at row 20. Any row entered below is excluded. Convert the range to an Excel Table with Ctrl+T and use =SUM(Table1[Amount]), which auto-expands. Alternatively, place the total formula above the data and insert rows between.

What happens if I save as .xls by mistake?

You lose access to newer functions like XLOOKUP, dynamic arrays, and some formatting — Excel shows "Compatibility Mode" in the title bar. Fix it with File > Info > Convert, which saves the file as .xlsx and unlocks the full feature set for future edits.

Does creating a spreadsheet in Excel cost anything?

Excel for the web costs nothing beyond a Microsoft account. Desktop Excel comes bundled with Microsoft 365 Personal (which includes Word, PowerPoint, and 1 TB of OneDrive storage) or as a standalone perpetual license. Prices vary by region and year; check Microsoft's site for current figures rather than relying on older quotes.