Opening a blank spreadsheet and naming it

When you open Excel, you see a grid of empty cells waiting for data. The fastest way to start is to open Excel itself — click the Windows Start button and type "Excel", or on a Mac, open Applications and find Microsoft Excel. Once it launches, you will see a screen with options for templates. Click Blank workbook in the top left. A new spreadsheet appears with columns labeled A, B, C and rows numbered 1, 2, 3 down the left side.

Before you enter any data, save the file with a name you will recognize later. Press Ctrl+S on Windows or Command+S on Mac. A dialog box opens asking where to save and what to call it. Type a clear name — "Monthly Budget" or "Inventory List" — and choose a folder you use regularly, like Documents. Click Save. Your spreadsheet now has a name at the top of the window, and Excel will save your changes automatically as you work.

Key Takeaways

  • A spreadsheet is a grid of cells organized by columns (letters) and rows (numbers), and you enter data by clicking a cell and typing.
  • Save your file when ready with a descriptive name so you can find it later and Excel will preserve your work automatically.
  • Organize related information in columns — put all names in column A, all dates in column B — so Excel can sort and calculate across rows.
  • Use the first row as headers (labels for what each column contains) so you and anyone else reading the sheet know what the numbers mean.
  • Format cells as numbers, currency, or dates before you enter data so Excel treats them correctly for calculations and sorting.

Entering data into cells and organizing it by column

Click on the first cell in the top left — it is labeled A1. Type your first piece of information. When you press Enter, the cursor moves down to A2. This is how you build a column of related data. If you want to move to a different column instead, press Tab, and the cursor jumps to the next column in the same row.

The key to a useful spreadsheet is organizing by column. Put all of one type of information in the same column. If you are tracking expenses, put all the dates in column A, all the amounts in column B, and all the categories in column C. This structure lets Excel sort your data, filter it, and run calculations across entire columns. A spreadsheet where information is scattered randomly across cells is hard to use and impossible to sort.

Start with a header row. Click cell A1 and type the label for that column — "Date", "Amount", "Category". Move to B1 and type the next header. This takes one minute and saves confusion later. When you or someone else opens the sheet in three months, the headers tell you when ready what each column contains.

Formatting cells before you enter numbers

Excel treats data differently depending on what type it is. A number that looks like "1500" might be currency, a count, or a measurement, and Excel needs to know which one so it can sort and calculate correctly. Before you enter data, format the cells to match what you are putting in them.

Click on the column header — the letter at the top — to select the entire column. Right-click and choose Format Cells. A dialog box opens with a list of categories on the left: Number, Currency, Date, Percentage, and others. Click the category that matches your data. For money, choose Currency and pick your country so Excel adds the correct symbol. For dates, choose Date and pick the format you use (like MM/DD/YYYY). Click OK. Now when you type in that column, Excel knows how to handle it.

If you forget to format before entering data, you can still fix it. Select the cells with data, right-click, choose Format Cells, and explore the correct format. Excel will reformat what you typed to match. This matters because a column formatted as Currency will right-align numbers and add a dollar sign, while a column formatted as Number will not.

Adding rows and columns when you need more space

As you work, you may realize you need another column or row. Right-click on a column letter or row number and choose Insert 1 Column Left or Insert 1 Row Above. Excel creates a blank column or row in that spot and shifts everything else over. This is faster and safer than trying to squeeze data into the wrong place.

If you need to add many rows at once — say you are building a list for the whole year and you know you need 52 rows — click on row 1, then hold Shift and click on row 52. Right-click and choose Insert. Excel adds 52 blank rows at once. You can do the same with columns: click column A, Shift-click column Z, right-click, and Insert.

Using basic formulas to calculate totals and sums

One of the main reasons to use a spreadsheet is to let Excel do math for you. A formula is an instruction that tells Excel to calculate something. The simplest formula adds up a column of numbers. Click on an empty cell below your data — say you have amounts in B2 through B10, so click on B11. Type =SUM(B2:B10) and press Enter. Excel adds all the numbers in that range and shows the total in B11.

The colon between B2 and B10 means "from B2 to B10, including everything in between". If your data is in rows 2 through 100, you can type =SUM(B2:B100) and Excel will add all 99 numbers. Other common formulas are =AVERAGE(B2:B10) to find the average, =COUNT(B2:B10) to count how many cells have numbers, and =MAX(B2:B10) to find the largest number. Type the formula, press Enter, and Excel calculates it when ready.

If you change a number in one of the cells the formula uses, Excel recalculates automatically. This is why spreadsheets are powerful — you can update one piece of data and all your totals and averages update without you having to do anything.

Sorting and filtering data to find what you need

Once you have data in your spreadsheet, you can sort it to see patterns or find specific rows. Click on any cell in your data, then click the Data menu at the top. Choose Sort. A dialog box opens asking which column to sort by. Pick the column you want to organize by — if you want to see expenses from smallest to largest, sort by the Amount column. Choose Ascending (smallest to largest) or Descending (largest to smallest) and click OK. Excel rearranges all your rows so they line up in that order, keeping each row's data together.

Filtering lets you hide rows that do not match what you are looking for. Click on any cell in your data and go to the Data menu, then choose AutoFilter. Small dropdown arrows appear in your header row. Click the arrow in any column — say the Category column — and a list appears showing every unique value in that column. Uncheck the ones you want to hide. Click OK and Excel shows only the rows that match. This is useful when you have hundreds of rows and want to see only expenses in one category, or only transactions from one month.

Saving your work and backing it up

Excel saves your file automatically if you saved it once with a name. But automatic saving is not the same as a backup. If your computer crashes or the file gets corrupted, you could lose everything. The safest approach is to save your file in two places: on your computer and in cloud storage.

To save to the cloud, click File at the top left, then Save As. Choose OneDrive or SharePoint if your workplace uses Microsoft 365, or choose another cloud service like Google Drive or Dropbox. Pick a folder and click Save. Now your spreadsheet exists in two places. If something happens to your computer, you can open the cloud version on any other device and keep working.

If you are working on a spreadsheet with other people, save it to OneDrive or SharePoint and share the link. Multiple people can open the same file and see changes in real time. This is much safer than emailing versions back and forth, where someone always ends up working on an old copy.

Frequently Asked Questions

What is the difference between a column and a row?

Columns run vertically down the page and are labeled with letters (A, B, C). Rows run horizontally across the page and are labeled with numbers (1, 2, 3). A cell is the box where a column and row meet — cell A1 is in column A, row 1. Think of columns as categories and rows as individual records.

Can I undo a mistake I made in my spreadsheet?

Yes. Press Ctrl+Z on Windows or Command+Z on Mac to undo your last action. You can press it multiple times to undo several actions in a row. If you undo too much, press Ctrl+Y or Command+Y to redo.

How do I copy a formula to other cells without typing it again?

Click the cell with the formula, then press Ctrl+C to copy it. Click on the cells where you want the formula to appear and press Ctrl+V to paste. Excel adjusts the cell references automatically — if you copy =SUM(B2:B10) down to the next row, it becomes =SUM(B3:B11).

What should I do if I accidentally delete a column with important data?

Press Ctrl+Z when ready to undo the deletion. If you have already closed the file, the data is gone. This is why saving backups to cloud storage matters — you can recover an older version of the file from your cloud provider's version history.

Can I print my spreadsheet or save it as a PDF?

Yes. Click File, then Print to print it, or Save As and choose PDF as the file type to save it as a PDF. Before you print, click File and Print Preview to see how it will look on paper — spreadsheets are often wider than a page, so Excel may split it across multiple pages.