Is there anything you have seen someone do in Excel and have always wondered how? Today we are discussing a new update; Show Changes for Excel on the Web.
Requirements and availability
- You might need to have Microsoft Excel installed on your laptop.
- A Microsoft office account.
Excel on the Web
Excel is synonymous with spreadsheets. Decades after the launch of Excel, this tool continues to be the most powerful spreadsheet software. Today, Excel is no longer a desktop app but an app that can be used on your windows, Mac, on mobile devices via iOS and Android, and on the web.
Microsoft Excel Online is a free, online version of Excel that includes most of the functions and features of the windows and Mac applications. The great thing about Excel Online is that it lets you collaborate with others in real-time, get insights, visualize and crunch numbers with Excel functions. You can also connect your spreadsheet with various web apps and have automated workflows.
And the best part is that it syncs with the Microsoft Excel application on your computer. In this article, we would get a brief overview of Show Changes.
Also, why did I say you might need to have Microsoft Excel installed on your computer. Well, let us find out.
Show Changes for Excel on the Web
Around April 2021, Microsoft announced a new feature in Excel for the web called Show Changes: “Show Changes in Excel will revolutionize the collaboration experience for one main reason: if you pour days and detail into the perfect Excel workbook, you may hesitate before sharing editing permissions with others. And you can’t have collaboration without sharing. Now, with Show Changes, you have the “safety net” of knowing that any changes done by others are being tracked for the entire workbook down to a single cell.”
Just like Google Sheets; on Microsoft Excel Online, you can now finally track changes on your shared workbooks.
Why is this important?
- This feature will encourage collaboration confidently since you can track changes.
- Worksheet History: This feature allows you to see edits made to your workbook within the past 60 days and shows:
- who changed what
- what was changed
- where was changed
- when it was changed
- The previous value of the cell for a quick reversion.
- Accept and reject changes; if a colleague accidentally overwrites or rewrites your formula. You can see the previous value and reject or accept this change.
- Bulk edits: You can make edits to a range of cells or just a specific sheet at the same time.
With the Excel desktop app installed, you can share your worksheets with your colleagues. Your colleagues can edit and make changes to the file on their personal computers. As long as the file is kept on OneDrive/SharePoint, the desktop app version changes will reflect on the online app version.
For more Excel tips keep up with UrBizEdge Blog and Subscribe to our YouTube channel
Don’t forget to register for our specially crafted Business Data Analysis Training, Power BI Training, and Financial Modeling training for professionals. Call Hope on 08082669002 or Faith on 09131370701, 01-6311885 for registration and other details.
You can also reply to this email or email info@urbizedge.com
