how to make an excel spreadsheet shareable in office 365

You can display the list of changes in a task pane via the Review tab > Show Changes:īulk changes are shown in the changes card allowing you to scroll through the list or collapse it via the ‘hide changes’ button: * Show Changes is also now available in the Excel desktop app. They’re retained for 60 days allowing you to see who changed what, where and when, along with the previous value of the cell. The Show Changes tool, currently only available in Excel Online*, enables you to keep track of edits to your workbooks across any end point: Desktop, Online, Mac, iOS, and iPad. More on at mentions and comments in different end points: Windows, MacOS, iOS, iPad, Web and Andriod here. In Excel Online you can also assign a task when you at mention someone:Įach comment is automatically time stamped and replies are shown in a thread when clicking on the cell:Īlternatively, you can show all comments in the comment pane by clicking on the ‘Show Comments’ button on the Review tab: You can mention co-workers in comments which will trigger an email notification to them: They’re inserted via the right-click menu, or the Insert and Review tabs:īy the way, the old style comments are now called ‘Notes’. New Threaded Comments allow you to string several comments together, including comments from other users, to form a conversation style thread.

Make sure Autosave is turned on to see changes they make in the workbook within seconds after they’re entered. Note: people from outside your organization who aren’t logged into Microsoft 365 display as a Guest Contributor: When someone else is editing the file, you’ll see their initials in the top right:Ĭlicking on the initials reveals what cell they’re working on and you can click the link to go to that cell location, open a contact card containing their email address, or start a group chat in Teams or Skype: Here you can specify what editing rights they’ll have (1) and then choose who to share the file with (2): Click the ‘Share’ button in the top right of the window:.Save your file to SharePoint Online or OneDrive.Make sure you’re signed into your Microsoft 365 account in Excel,.To share an Excel file with your co-workers from in or outside your organization: Share and Collaborate in Excel Step by Step: xlsx file please ensure your browser doesn't change the file extension on download.

Excel for Decision Making Under Uncertainty Courseĭownload the Excel Workbook and follow along.

Excel for Customer Service Professionals.

How to make an excel spreadsheet shareable in office 365