Opening Excel and starting a blank document

To create a new Excel document, open Microsoft Excel on your computer. When the program launches, you will see a start screen with template options. Click the blank spreadsheet thumbnail — it shows a grid of empty cells — to begin with a fresh document.

If Excel is already open, go to File in the top left corner, then select New. Again, choose the blank spreadsheet option. Either way, you will see a grid of columns (labeled A, B, C, and so on) and rows (labeled 1, 2, 3, and so on). Each box where a column and row meet is called a cell. This is where you enter your data.

Key Takeaways

  • A new Excel document opens as a blank grid; click on any cell and start typing to enter data.
  • Columns run vertically and are labeled with letters; rows run horizontally and are labeled with numbers.
  • Save your document when ready by pressing Ctrl+S (or Cmd+S on Mac) and give it a name ending in .xlsx.
  • Format text by selecting cells, then using the toolbar buttons for bold, font size, or background color.
  • Use formulas like =SUM() to add numbers automatically, or =AVERAGE() to find the middle value of a range.

Entering data into cells

Click on any cell to select it — you will see a dark border around it and the cell reference (like A1) will appear in the name box on the left. Type your data directly. You can enter text, numbers, dates, or a mix. Press Enter when you finish typing in that cell, and the cursor moves down to the next row automatically.

To move between cells without pressing Enter, use the arrow keys on your keyboard. You can also click any cell directly to jump to it. If you make a mistake while typing but before you press Enter, press Backspace to delete characters, or press Escape to cancel the entire entry and start over.

Organizing data into rows and columns

Think of rows as records and columns as categories. For example, if you are tracking household expenses, put the expense type in column A (Groceries, Utilities, Rent), the amount in column B, and the date in column C. Each row then represents one transaction. This layout makes it straightforward to sort, filter, or calculate totals later.

Start with a header row at the top. Click cell A1 and type the name of your first category. Press Tab to move to B1 and type the next category name. Tab moves you right across the row. Once your headers are in place, click A2 and begin entering your actual data below. This structure is what makes a spreadsheet useful instead of just a list in a text document.

Saving your document with the right format

Save your work when ready after creating it. Press Ctrl+S on Windows or Cmd+S on Mac. A dialog box will appear asking you to name your file and choose where to save it. Give your document a clear name — for example, "Household Budget 2024" or "Expense Tracker." Do not worry about the file extension; Excel automatically adds .xlsx to the end, which is the standard Excel format.

If you are sharing the document with someone who uses an older version of Excel, you can save it as .xls instead, but .xlsx is the modern standard and works on Windows, Mac, and even in free online versions like Excel Online. After you save once, pressing Ctrl+S again will update the same file without asking for a new name.

Making your spreadsheet easier to read

Select the cells you want to format by clicking one cell and dragging to another, or by clicking the first cell, holding Shift, and clicking the last cell. Once cells are selected, the toolbar at the top shows formatting options. You can make text bold by clicking the B button, change the font size using the dropdown that shows a number, or add a background color by clicking the paint bucket icon.

You can also make your header row stand out by selecting it (click the row number 1 on the left side to select the entire row) and then explore bold text and a background color. Widen columns by positioning your cursor on the line between two column letters at the top until it becomes a resize arrow, then dragging left or right. These small changes make data much easier to scan.

Using formulas to calculate automatically

Formulas are instructions that tell Excel to do math for you. Click a cell where you want the result to appear and type an equals sign (=) to start a formula. The most common formula is =SUM(), which adds numbers. For example, if you have expenses in cells B2 through B10, click cell B11 and type =SUM(B2:B10). Press Enter, and Excel shows the total.

Other useful formulas include =AVERAGE() to find the middle value, =COUNT() to count how many numbers are in a range, and =MAX() or =MIN() to find the highest or lowest number. To use any of these, type the formula name, open a parenthesis, select the range of cells you want to calculate (like B2:B10), close the parenthesis, and press Enter. Excel updates the result automatically if you change any of the numbers in that range.

Printing or sharing your spreadsheet

To print your spreadsheet, press Ctrl+P on Windows or Cmd+P on Mac. A print preview appears showing how your document will look on paper. You can adjust the number of copies, choose which pages to print, and set the paper size. Click Print to send it to your printer.

To share your spreadsheet with someone else, you can email the file directly, or use OneDrive or Google Drive to store it in the cloud and send them a link. If you save to OneDrive (which is built into Windows), you can also use Excel Online to open and edit the file in a web browser without installing the full program. This makes it straightforward for multiple people to work on the same spreadsheet at the same time.

Frequently Asked Questions

Can I undo a mistake I just made?

Yes. Press Ctrl+Z on Windows or Cmd+Z on Mac to undo your last action. You can press it multiple times to go back several steps. If you undo too far, press Ctrl+Y (or Cmd+Y on Mac) to redo.

What is the difference between a column and a row?

Columns run vertically from top to bottom and are labeled with letters (A, B, C). Rows run horizontally from left to right and are labeled with numbers (1, 2, 3). A cell is the intersection of a column and row — for example, cell A1 is in column A, row 1.

How do I add more rows or columns to my spreadsheet?

Right-click on a row number or column letter and select Insert. A new row or column appears at that location. You can also select multiple rows or columns by clicking and dragging across their numbers or letters, then right-clicking to insert multiple at once.

Can I use Excel on my phone or tablet?

Yes. Microsoft offers free Excel apps for iPhone, iPad, and Android devices. You can also use Excel Online by opening a web browser and signing into your Microsoft account. Both versions let you view and edit spreadsheets, though some advanced features are only available in the desktop program.

What should I do if my spreadsheet is getting too large to manage?

Consider splitting your data across multiple sheets within the same file. At the bottom of the window, right-click the sheet tab and select Insert Sheet. Give it a name like "2024 Expenses" or "Customer List." You can then organize related data on separate sheets and reference one sheet from another using formulas.