Create and edit spreadsheets online
Excel Online allows you to create, view, edit spreadsheets in your web browser, and it allows you to collaboratively edit spreadsheets with your colleagues on Office 365 in real time.
Excel Online creates fully Office-compatible xlsx files that you can open with Excel on the desktop, and share with colleagues, partners and customers using OneDrive or email.
What you’ll see
Excel Online is launched from the Office 365 menu and opens in a new browser tab. The default launch screen is only slightly different to the launch screen in Excel 2013 and Excel 2016.
Here’s what you’ll see when launching Excel Online:
- A list of recently opened spreadsheets
- New blank document and online templates
- ‘Get Excel for your device’, and your Office 365 account links.
When you’ve chosen a new blank spreadsheet, or a template from the list, Excel will open and show the familiar tab menu.
The editing screen has these main features:
A. The tabs menu, with File, Home, Insert, Data, Review, View, and Edit in Excel, to open the spreadsheet in whatever version of Excel you have on your computer. Each tab shows many of the functions of desktop Excel
B. The spreadsheet editing field
C. Sheet control – create a new sheet, rename or move a sheet and navigate through sheets
D. Share button
Using Excel Online
Excel Online automatically saves your changes as you enter data and amend the spreadsheet – there’s no need for a save button. It’s immediately familiar for users of Excel 2013 or Excel 2016, with many of the functions you’ll see in the desktop version.
A few of the less commonly used functions aren’t in Excel Online, but it’s a very capable spreadsheet program. Here’s a comparison of the File tab menu between Excel Online and Excel 2013:
One of the greatest features of Excel Online is that you can collaborate in real time with colleagues, creating a spreadsheet together and saving time. Co-authoring is easy and you can see in real time what changes your colleagues are making to the document.
Integration with other Office 365 apps
Excel Online saves documents to your OneDrive folder, where you can share them with people in your team, attach them in emails, download them to your desktop or share them on SharePoint.
We have an ever-growing list of articles about the apps in Office 365, including Mail, Calendar, People, OneDrive, SharePoint and more. To view them all see our list of Office 365 blogs.
Future posts and more details
We will continue to provide introductory blogs about the apps in Office 365 to help you get started. If you want to know more about how Office 365 can help your business, contact Create IT.