What is Microsoft Excel Online?
- Office Online - Free: With a Microsoft account, you can use Office Online and save up to 5GB of files in OneDrive for free.
- Office 365 Personal - $6.99/month: Get Office apps on your computer, and 1TB of OneDrive storage.
- Office 365 Home - $9.99/month: Get Office apps for 5 people in your family, along with 1TB of OneDrive for each user.
- Office 365 Business - $8.25/month: Get Office on your work computer, with 1TB OneDrive for Business storage with professional integrations.
- Office 365 Business Premium - $12.50/month: Get Office on your work computer and 1TB OneDrive for Business storage, along with email and video conferencing.
Excel Online Basics
Functions
SQL.REQUEST
, JIS
, and EUROCONVERT
. Everything else is supported; even if the function isn't shown in the auto-complete dropdown, it'll still work once you enter it correctly.=
followed by your function name. Excel will auto-complete the function name—press the Tab key to accept the suggested function—and then give you tips on what data you should include in the function. Or, you can look through the included functions by clicking the fx button right under the toolbar.Charts
![Mac Mac](/uploads/1/2/5/2/125281914/309736137.gif)
Tables
Gather Data with an Excel Survey
Share and Collaborate in Microsoft Excel Online
Add Comments to Your Spreadsheet
Share a Copy of Your Spreadsheet
.xlsx
formatted copy of your spreadsheet. Alternatively, you can download an OpenDocument formatted .ods
spreadsheet to use in alternative spreadsheet tools like OpenOffice and LibreOffice.Moving Your Existing Spreadsheets to Excel Online
.xlsx
format that you can open in any modern version of Excel. That's one of the best features of Excel Online: it saves your data in real files, so your spreadsheets aren't trapped in the cloud.Opening Older Spreadsheets in Excel Online
.xlsx
and .xlsm
files, and with the latter it won't be able to run any macros included in the workbook. If you upload an older .xls
file, or a .csv
spreadsheet to OneDrive and then try to open it online, Excel will just download the file to your computer instead of opening it..xlsx
format. Just open them in Excel, open the Save as… dialog from the File tab or menu, then select Excel Workbook (.xlsx). You can then add those files to OneDrive to view and edit them online.Extend Microsoft Excel with Add-ins and Integrations
![Headings Headings](/uploads/1/2/5/2/125281914/947760227.png)
- Advanced Find and Replace to search deeply through your spreadsheets
- Duplicate Remover to remove duplicate data
- Split Text to Columns to make your data easier to use in a spreadsheet
- Trim Spaces to remove extra blank spaces from your spreadsheets
- Compare Text to find differences between text
- Merge Cells to merge rows, columns, or entire ranges
- Solver to solve optimization problems for statistics
- Bing Maps to create maps from your spreadsheet data
- Blockspring to add extra data analysis functions to Excel
Connect Excel to 700+ Apps with Zapier Integrations
Learn More About Spreadsheets with Zapier
- If you're just getting started with spreadsheets, check out The Beginner's Guide to Spreadsheets
- Want to manage contacts in a spreadsheet? Here's how to build a spreadsheet CRM
- Spreadsheets can help you write faster, too. Here's how to outline, organize notes, create HTML, and more in spreadsheets
- Then, create a business dashboard in a spreadsheet, and to make it work in Excel, just use the Keluro Web Analytics add-on to get Google Analytics data in your spreadsheet
Your friend Tomas finished a 5-K run last weekend, and you want to see the top 10 finishers and compare his time against theirs. You searched for his name and found him, down in row 180. How can you see his result and the top 10 finishers, who are at the top of the worksheet, at the same time? By splitting the worksheet, you can scroll down in the lower pane and still see the top rows in the upper pane.
To split this worksheet, you select below the row where you want the split – selecting row 13 splits the worksheet below row 12. Then, you click View > Window > Split. You remove the split by clicking the Split button again.
You can split a worksheet on columns, too. Select the column to the right of the column where you want the split, and use the Split command. Or, you can split on a row and a column. Select the cell below and to the right of where you want the split, and click Split. Here, because D5 was selected, columns to its left (A-C) and rows above it (1-4) are frozen by the split. Then, by selecting a row below row 4 and scrolling up, you can skip seeing rows 5 through 9. And by selecting a column to the right of column C and then scrolling to the right, you can skip seeing columns D through F and focus in on Q4 and YTD totals in columns G and H.
To undo a split, just click View > Window > Split again.