
Learning how to use online Excel is one of the most useful skills you can pick up, because it lets you work with spreadsheets from any computer, without installing any software. Online Excel, also known as Excel for the web, is the free version of Microsoft Excel that runs in your browser, and it is part of Microsoft 365. You can open it on a Windows computer, a Mac, a Chromebook, or even a tablet, and your files are saved automatically in OneDrive, so you never lose your work.
This guide explains how to get started, how to create and edit spreadsheets, and how to use the features that matter most. You do not need any previous experience with spreadsheets to follow it. If you can type and click, you can build a useful workbook by the end of this guide.
The biggest advantage of online Excel is that it is free and it goes wherever you go. You do not need to buy Microsoft Office, and you do not need a powerful computer, because the work is done in the browser. A student can start a spreadsheet on a school computer and finish it on a home laptop, a freelancer can share a budget with a client who can open it in their own browser, and a team can edit the same spreadsheet at the same time, seeing each other's changes as they happen.
What Is Online Excel?
Online Excel is the web version of Microsoft Excel. It runs in your browser, and your files are stored in OneDrive, which is Microsoft's cloud storage service. You sign in with a free Microsoft account, open a workbook, and work on it from any device with an internet connection.
Why Should You Use Online Excel?
There are several reasons to choose the online version over a desktop-only spreadsheet. The first is cost: the basic version is free with a Microsoft account. The second is access: you can open your files from any computer, without carrying a USB stick or emailing files to yourself.
What Do You Need Before You Start?
To use online Excel, you need a free Microsoft account, which is the same account you use for Outlook, OneDrive, or Skype. If you already have one, you can sign in straight away. If you do not have one, you can create one in a few minutes with an email address and a password.
What Can Online Excel Do, and What Can It Not Do?
Before you start, it helps to know what online Excel can and cannot do compared with the desktop version. Online Excel handles the everyday tasks very well: entering data, formatting cells, sorting and filtering, and using common formulas such as SUM, AVERAGE, and COUNT. It also handles charts, tables, and basic conditional formatting.
| Feature | Online Excel | Desktop Excel |
|---|---|---|
| Entering and editing data | Yes, full support | Yes, full support |
| Formulas such as SUM and AVERAGE | Yes, full support | Yes, full support |
| Charts and tables | Yes, basic and common types | Yes, more types and options |
| Sorting and filtering | Yes | Yes |
| Conditional formatting | Yes, basic rules | Yes, full rules |
| Macros | No, or very limited | Yes, full support |
| Complex pivot tables | Limited | Yes, full support |
| Working offline | Needs an internet connection | Yes, works offline |
| Cost | Free with a Microsoft account | Paid, or part of Microsoft 365 |
How to Get Started With Online Excel
Follow these steps to open online Excel and create your first workbook. The whole setup takes only a few minutes, and you only need to do it once.
The quickest path to your first workbook looks like this:
- Sign in at office.com with your free Microsoft account.
- Click the green Excel icon to open Excel for the web.
- Click Blank workbook, or pick a template for your job.
- Type your headings in the first row and your data below.
- Use a formula such as SUM to calculate a total, then share the file.
Step 1: Go to the Microsoft 365 Website and Sign In
Open your web browser and go to the Microsoft 365 website, then sign in with your Microsoft account. Type office.com into the address bar, press Enter, and click Sign in in the top right corner. Enter your email address and password, and you will see the Microsoft 365 home page, with icons for Word, Excel, PowerPoint, and OneDrive.
This page is your starting point for every online Office document, and you can return to it at any time by typing office.com into your browser. If you have trouble signing in, check that you are using the right email address, and use the password reset link if you have forgotten your password.
Step 2: Click the Excel Icon to Open Excel for the Web
Click the Excel icon on the Microsoft 365 home page to open Excel for the web. The icon is green with a white X, and it sits near the top of the page alongside the other Office apps. Clicking it will take you to the Excel start page, where you will see a list of recent workbooks you have opened, and a set of templates you can use to start a new one.
If you have never used online Excel before, the recent list will be empty, and that is perfectly normal. The templates are worth a look, because they cover budgets, calendars, invoices, and to do lists, and each one is already set up with headings, formulas, and formatting.
Step 3: Create a New Blank Workbook
Create a new blank workbook by clicking Blank workbook on the Excel start page. A new spreadsheet will open in your browser, with a grid of cells, a ribbon of tools at the top, and a formula bar just below it. The workbook is given a default name, such as Book 1, and it is saved automatically in your OneDrive as you work.
You do not need to press save, because online Excel saves every change within a few seconds. Click on the title at the top of the screen to rename the workbook to something meaningful, such as Monthly Budget or Sales Report. A clear name makes the file easy to find later in OneDrive.
Step 4: Enter Your Data Into the Cells
Enter your data by clicking on a cell and typing. Click on cell A1, type a heading such as Name or Product, and press Enter or Tab to move to the next cell. Keep typing your data row by row, with one piece of information in each cell.
Use the first row for headings, so that each column has a clear title, and keep the data in each column consistent, with dates in one column, numbers in another, and text in another. Clean, organised data is the foundation of a useful spreadsheet, and it makes every later step easier. Avoid putting two different kinds of information in the same cell, because that makes formulas and sorting harder.
Step 5: Format Your Cells So the Sheet Is Easy to Read
Format your cells so that your spreadsheet is easy to read. Select the heading row by clicking on the row number, and then click the Bold button on the Home tab to make the headings stand out. Use the Fill Colour button to add a light background colour to the headings, and use the Align buttons to centre text or numbers where it helps.
Change the number format by selecting a column of numbers and choosing Currency, Percentage, or Date from the Number Format menu. Good formatting does not change the data, but it makes the spreadsheet much easier to understand at a glance. Keep colours simple, and use the same style for similar things throughout the sheet.
Step 6: Use a Formula to Calculate a Total or an Average
Use a formula to calculate a total, an average, or another result. Click on the cell where you want the answer to appear, type an equals sign, and then type the formula, such as SUM(B2:B10) to add up the numbers in cells B2 to B10. Press Enter, and Excel will show the result.
You can also use the AutoSum button on the Home tab, which will guess which cells you want to add and write the formula for you. Formulas update automatically when you change the numbers they refer to, which is the real power of a spreadsheet. Change one number, and every total that depends on it updates at once.

Step 7: Sort and Filter Your Data
Sort and filter your data to find what you need quickly. Click on any cell inside your data, go to the Data tab, and click Sort to arrange the rows in order, such as from the smallest number to the largest, or from A to Z. To filter, click the Filter button on the Data tab, and small arrows will appear beside each heading.
Click an arrow to choose which values to show, and Excel will hide the rows that do not match. Sorting and filtering are essential when your spreadsheet grows to hundreds of rows, because they let you find the important information without scrolling through everything. Remember to clear a filter when you are done, so you do not miss rows that are hidden.
Step 8: Share Your Workbook and Work Together in Real Time
Share your workbook with someone else, and work on it together in real time. Click the Share button in the top right corner of the screen, type the email address of the person you want to share with, and choose whether they can edit the file or only view it. Click Send, and they will receive a link they can open in their own browser.
How Does Saving and Version History Work?
Saving in online Excel is automatic, and you can see the save status at the top of the screen. When you make a change, the status will say Saving, and a moment later it will say Saved, or it will show the time of the last save. Because the file is stored in OneDrive, you can close the browser at any time without losing your work, and you can reopen the file from any device by signing in to office.com.
Version history is another useful feature that protects you from mistakes. If you delete a row by accident, or if a formula goes wrong, you can go to File, then Info, then Version History, and see a list of earlier versions of the workbook, with the time each one was saved. Click on an earlier version to see what it looked like, and restore it if you need to. This is much easier than trying to undo a long series of changes, and it gives you confidence to experiment, knowing that you can always go back.
How to Make Charts and Tables in Online Excel
Charts turn your numbers into pictures that are easier to understand, and online Excel makes them simple to create. Select the data you want to chart, including the headings, go to the Insert tab, and click on the chart type you want, such as a column chart, a line chart, or a pie chart.
Excel will draw the chart on your sheet, and you can move it, resize it, and change its colours using the options that appear when you click on it. A chart is worth adding whenever you need to show a trend, compare values, or present your results to someone else. Keep the chart simple, with a clear title and labels, so the reader understands it at a glance.
Tables are a useful way to organise data in online Excel, because they add filters, banded rows, and a total row with a single click. Select your data, go to the Insert tab, and click Table, then confirm that your data has headings and click OK. Your data will become a table with a coloured heading row and alternating row colours, and a filter arrow will appear beside each heading.
Conditional formatting highlights cells that meet a rule you set, such as numbers over a target, dates that are overdue, or text that contains a certain word. Select the cells you want to format, go to the Home tab, click Conditional Formatting, and choose a rule, such as Highlight Cells Rules and then Greater Than. Type the value, choose a colour, and click OK. The matching cells will change colour automatically, and they will update when the numbers change.
How to Freeze Panes and Print From Online Excel
Freezing panes keeps your headings visible when you scroll down a long spreadsheet. Click on the row below your headings, go to the View tab, click Freeze Panes, and choose Freeze Panes. Now, when you scroll down, the heading row will stay at the top of the screen, so you always know which column is which.
Printing from online Excel is straightforward, but it needs a little setup to look right. Go to File, then Print, and you will see a preview of how your spreadsheet will look on paper. Use the Page Setup options to choose landscape or portrait, set the margins, and fit the sheet to one page if it is slightly too wide.
How to Share Safely and Control Who Can Edit?
Collaboration in online Excel is safe, because you control who can see and edit each file. When you share a workbook, you can choose whether the other person can edit it or only view it, and you can stop sharing at any time by going to the Share menu and changing the permissions.
Does Online Excel Work Offline?
One question people ask is whether online Excel works offline. The answer is that it needs an internet connection to open and save files, because the files live in OneDrive. If you need to work offline, you can use the desktop version of Excel, or you can open the file in the OneDrive app on your phone, which can keep a copy for offline use.
For most people, though, the online version is used at home or in the office, where the internet is available, and the automatic saving is worth more than offline access. If you know you will be offline, download a copy before you go, by going to File, then Save As, then Download a Copy, and work on that copy until you are back online.
Common Mistakes When Using Online Excel
New users make the same few mistakes, and avoiding them will save you time and frustration. The first is mixing different kinds of data in one column, which makes sorting and formulas unreliable. Keep dates in one column, numbers in another, and text in another, and use the first row for headings only.
The second mistake is typing numbers as text, or typing a total by hand instead of using a formula. A typed total will not update when the numbers change, so it quickly becomes wrong. Always use a formula for a total, an average, or any value that depends on other cells.
Mistake 2: Closing the Tab Before the File Has Saved
Online Excel saves automatically, but it takes a few seconds after each change. Check that the status at the top says Saved before you close the tab, especially after a large paste or a long editing session.
Mistake 3: Sharing an Anyone With the Link for Sensitive Data
A public link is convenient, but anyone who gets it can open the file. For budgets, grades, or personal data, share only with named people, and check the permissions from time to time.

Related: How to Calculate Average in Excel
How to Work Faster With Templates and Shortcuts
If you are new to spreadsheets, start with a template instead of a blank workbook. Online Excel offers templates for budgets, calendars, invoices, to do lists, and many other common jobs, and each one is already set up with headings, formulas, and formatting. Click on a template on the Excel start page, and a copy will open ready for you to fill in with your own data.
Keyboard shortcuts make online Excel much faster once you learn a few of them. Ctrl and C copies a cell, Ctrl and V pastes it, Ctrl and Z undoes a change, and Ctrl and S saves, although online Excel saves automatically. Ctrl and Home takes you to cell A1, Ctrl and End takes you to the last used cell, and Ctrl and the arrow keys jump to the edge of a block of data.
- Ctrl and C to copy, Ctrl and V to paste, Ctrl and Z to undo.
- Ctrl and Home to jump to cell A1, Ctrl and End to jump to the last used cell.
- Ctrl and the arrow keys to jump to the edge of a block of data.
- Ctrl and S to save, even though online Excel saves automatically.

Related: Merge Cells in Excel
Frequently Asked Questions
1. Is online Excel really free?
Yes, Excel for the web is free with a Microsoft account. You get five gigabytes of free OneDrive storage, and you can create, edit, and share workbooks without paying. A paid Microsoft 365 plan adds more storage and the desktop apps, but it is not needed for everyday use.
2. Do I need to install anything to use online Excel?
No, online Excel runs in your web browser, so there is nothing to install. Open office.com, sign in, click the Excel icon, and you can start working straight away on Windows, Mac, or Chromebook.
3. Will my online Excel files open in desktop Excel?
Yes, both versions use the same xlsx file format. You can download a copy from File, then Save As, then Download a Copy, and it will open normally in desktop Excel or Google Sheets.
4. Can several people edit the same workbook at the same time?
Yes, that is one of the best features of online Excel. Share the file with edit permission, and each person will see the others' changes within seconds, with coloured cursors showing where everyone is working.
5. What happens if my internet connection drops while I work?
Online Excel will try to save your changes when the connection returns. Check that the status at the top says Saved before you close the tab, and download a copy before you go offline if you know you will lose your connection.
Conclusion: Start Using Online Excel Today
To sum up, online Excel is a free, powerful, and easy way to work with spreadsheets in your browser. Sign in at office.com, open Excel, create a blank workbook or choose a template, enter your data, format it clearly, and use formulas to calculate your results.
Share the file when you need to work with others, and let the automatic saving and version history protect your work. With these basics in place, you can handle budgets, lists, reports, and plans from any computer, and you can move on to charts, tables, and more advanced features as your confidence grows.
Key Takeaways
- Online Excel is free with a Microsoft account and runs in any modern browser.
- Your files are saved automatically in OneDrive, with version history to undo mistakes.
- Start with a blank workbook or a template, use the first row for headings, and keep each column consistent.
- Use formulas such as SUM and AVERAGE instead of typing totals by hand.
- Sort, filter, freeze panes, and use tables and charts to make large sheets easy to read.
- Share with named people, choose edit or view permission, and check that the file says Saved before you close the tab.