قالب وردپرس درنا توس
Home / Tips and Tricks / View changes when collaboration in Excel for the web

View changes when collaboration in Excel for the web

Microsoft Excel logo

While collaborating on a spreadsheet can be helpful, it can also be a bit of a struggle. Something changes and you’re not sure who did it or when. With Show Changes in Microsoft Excel for the web, you don’t have to worry anymore!

With a simple click, you can see who made a change to your workbook or a particular sheet and when. In addition, you can apply a filter to narrow down the exact cells in question. If you and your colleagues are collaborating online in Microsoft Excel, here̵

7;s how to take advantage of the Show Changes feature.

Open View changes in Excel for the web

Accessing the View Changes option online in Microsoft Excel couldn’t be easier. Open your workbook, select the Review tab, and click “Show Changes” in the ribbon.

On the Review tab, click Show changes

This will open a sidebar on the right side of your screen, which you can minimize by clicking the arrow icon. Click that arrow to expand the Changes sidebar again.

Click the arrow to minimize changes

View changes made in Excel

When you first open the View Changes pane, you will see all the changes made to the workbook. Each operation lists the user’s name, the time and/or date, and the change.

Show changes for a workbook in Excel

If most of the changes were made at the same time by the same person, they are consolidated. Click on ‘View changes’ to see them all. You can then click “Hide changes” to collapse the list again.

Click View changes to expand

You may be working on a spreadsheet at the exact same time as someone else. If this happens and changes are made, you’ll receive a “View new changes” message at the top of the “Changes” sidebar. Click on the message in green to refresh and see what’s new.

Click View New Changes

Filter the changes

A great feature of Show Changes is that you can filter the edits you see. This is ideal in large workbooks where you see a lot of changes in that sidebar. You can filter by sheet or cell range.

At the top of the Changes sidebar, click the filter icon to bring up a list of options.

Click on the Filter drop-down list

To filter by spreadsheet name, move your cursor to “Sheet” and choose one from the pop-out menu.

Select a sheet to filter

To filter by range of cells, first make sure you are on the tab for the sheet containing that range. Then click the filter drop-down and select ‘Range’.

Select Range for the filter

Enter the range of cells in the text box that appears and click Commit (green arrow button) on the right.

Enter the cell range and click Commit

You will then see results for the cell range filter.

Cell Range Filter Results

When you’re done with a filter, you can clear it to see all the changes in the workbook or apply a new filter. Click the Filter drop-down list and choose “Clear Filter.”

Select Clear filter

View changes is currently only available in Excel for the web. Hopefully this is a feature that Microsoft will bring to its desktop and mobile versions of Excel later on. It is definitely a useful tool for working on spreadsheets with your team.

RELATED: What’s the difference between Microsoft Office desktop, web, and mobile apps?

Source link