With Excel Online:
Share your workbook with others and collaborate on the same file at the same time.
Add tables and charts to make your data visual.
Create a survey.
Filter a table.
Use AutoSum to quickly add totals.
When you share your workbook with other people, you can all work on the file at the same time in Excel Online. For more information, see Collaborate on Excel workbooks at the same time with co-authoring.
Create a workbook
Sign in to office.com/signin, select the Office 365 App Launcher , and then select Excel.
Select New blank workbook, open a Recent file, or select one of the templates.
Share your workbook
Enter the names or email addresses of the people you want to share with.
Select Can edit or Can view.
Include a message if you'd like and select Share.
You can also select Get a link to create a link that you can copy into an email, or select Shared with to stop sharing.
Co-author a workbook
After you share your file, you can work on it at the same time with others.
For the best experience, work together in Excel Online and see real-time changes.
Under Share, you will see the names of who else is also editing the file.
Colored cells will show you exactly where in the document each person is working. Click a color to see who's editing that cell.
Add, edit, delete, and show comments
Add a comment – on the Insert or Review tab, select Comment, type your comment, and select Post.
A little red triangle appears in the corner when a cell has a comment.
Edit - select Review > Edit Comment.
Delete – select Delete Comment, or select the in the comment.
Show - select Review > Show Comments.
Chat while editing
If there's another person editing your file, select Chat to open a chat window.
Type some text and press Enter.
Your conversations won't be saved when you close a file. If you'd like to keep a record of your chat and have ongoing conversations, talk with your colleagues in Teams.
Name your file
At the top, you'll notice that Excel Online automatically names your workbook Book1 (or Book2, or Book3...). To give it a more meaningful name:
Click the current name.
Type a name that works for you.
Anything you do in Excel Online — from naming the file, to working in the cells — is saved automatically.
Do your work
After you've named your file, you can do what you usually do: enter data, add formatting, type formulas, make charts, and so on. All features are available to you on the tabs at the top.
If you find the tabs are taking up too much space, double-click a tab and the ribbon collapses to give you more room.
Edit using the desktop app
If you find Excel Online is missing something you need, you can always edit the file in the full Excel desktop application. To switch to the desktop app:
Click Edit in Excel.
The Excel app will launch and open the file.
When your changes are saved in the application, they get saved to OneDrive. There's no need to do a "Save As" and re-upload the file.
Tip 1: The Home tab has what you need
The Home tab has the most frequently used buttons and features: Clipboard buttons (like cut, copy, paste) and formatting options (like colors, alignment, and number formatting).
Make sure you check out the right side of the Home tab. That's where you can insert rows and columns, sum numbers, and sort.
Tip 2: The Insert tab is for tables, charts, etc.
The Insert tab is the place to insert special things, like tables, charts, hyperlinks, and so on.
If you need to insert rows, columns and cells, then go to the right side of the Home tab.
Tip 3: Need a form? Start with a survey.
If you want to insert a form that collects data, first create a survey in OneDrive, by clicking New > Excel survey. Then you'll have both a survey and a workbook that collects the data from the survey.
Tip 4: Freezing columns and rows at the same time
If you want to freeze columns and rows at the same time, select a cell that is below the rows you want to freeze, and to the right of the columns you want to freeze. Then click View > Freeze Panes > Freeze Panes.
Tip 5: You can filter, with a table
If you need to filter, click inside some data, and then click Insert > Table. That will give you filter buttons to work with.
Tip 6: Let AutoSum detect your range — no selection needed
If you have numbers in continuous cells, then the AutoSum button makes things easier. It will detect the range to be summed automatically. In this example, it detected that cells C2 through C7 needed to be summed. There's no need to type in the cell references.
Tip 7: Work offline
OneDrive syncs files to your computer. Open File Explorer or the Mac Finder and you'll see the OneDrive folder on the left. Copy files into this folder, move them around, and so on. If you disconnect from the Internet, you can open and edit these files offline. When you reconnect, they'll get synced to OneDrive.
Get help with Tell me
Select Tell me what you want to do at the top of the screen.
Type what you want to do.
For example, type freeze to learn how to freeze panes to lock rows or columns.