How to Create a Spreadsheet in Excel – Beginner Setup

2026-08-07

  • Excel
  • spreadsheet
  • beginner
  • how to use excel
  • tutorial

Create a new workbook

How to create a spreadsheet in excel starts with a blank file:

  1. Open Excel → Blank workbook (or File → New).
  2. Rename Sheet1 (right-click tab → Rename) to something clear, e.g. Sales.
  3. Save early: File → Save As → .xlsx (avoid legacy .xls when possible).

On Windows, Ctrl+N creates a new workbook; Ctrl+S saves.

Layout that stays usable

  1. Put headers in row 1 only—one header per column, no merged title row above data.
  2. Enter one record per row; keep numbers as numbers (not text with currency symbols in every cell).
  3. Select the data range → Insert → Table (Ctrl+T). Tables make filters, structured refs, and charts easier.
  4. Freeze the header: select row 2 → View → Freeze Panes → Freeze Panes.

First formulas and views

Need Start here
Sum a column =SUM(B2:B100) or Table totals row
Look up a value VLOOKUP guide / Formula AI
Keyboard speed Shortcuts cheat sheet

When the data is messy

New sheets often start from CSV exports. You do not have to clean everything inside Excel:

Problem Tool
Duplicate rows Remove duplicates
First + last name in two columns Merge columns / guide
Several department files Excel Merge
Dates stored as text Date convert

Next skills after “create a spreadsheet”

Follow the full path in How to learn Excel: charts, pivots, then optional macros.