How to Show Changes in Microsoft Excel on Desktop

Configurare noua (How To)

Situatie

Do you see something unusual in your Excel spreadsheet? Wondering how the change may have happened? Whether you’re working with others or alone on an Excel sheet, there’s a simple way to see the changes that take place.

With the click of a button, you can view the changes in a workbook for each sheet. You can see who made the edit, when they made it, and exactly what changed. This feature was first made available in Excel for the web but was later added to the Excel desktop application on Windows and Mac for Microsoft 365 subscribers.

Solutie

Pasi de urmat

With the Show Changes feature, you can see edits to cell values and formulas for up to 60 days. This includes changes involving moving, sorting, inserting, and deleting. However, you can’t see changes to charts, shapes, objects, pivot table operations, formatting, hidden cells, filtering, or deleted locations.

Open your Excel workbook, go to the Review tab, and select “Show Changes” in the Changes section of the ribbon.

Show Changes on the Review tab in Excel

  • You’ll see a panel open on the right side with a list of changes for the workbook.
  • You’ll see the person who made the change with the date and time.
  • You can then review the sheet, item, and cell that was edited.

Show Changes panel in Excel

To see the change in the sheet, select the cell reference, sheet name, or edit icon (pencil) in the box for the change in the sidebar. You’ll then see the changed item highlighted in the sheet.

Highlighted cell that was changed

Use a Filter to Show Changes
  • By default, you’ll see all the changes to a workbook when you click the Show Changes button.
  • But you can also filter the list to view a specific sheet or range of cells.
  • With the Show Changes sidebar open, select the filter drop-down arrow at the top.
  • You can move your cursor to Sheet and then pick a particular spreadsheet in the pop-out menu to view only those changes.

Filter by sheet for Show Changes

  • You can also choose “Range” to see changes to certain cells.
  • Enter the cell range (with the sheet name) in the box to the right or select the cells on the sheet to populate the Range box.
  • Then, click the green arrow to view those changes.

Filter by range for Show Changes

When you finish using the filters, select “Clear Filter” in the drop-down menu. The panel then shows the entire list of changes again.

Clear Filter in the Show Changes Filter menu

Seeing the changes you or your collaborators make in Excel is easier than ever. Be sure to keep this guide bookmarked for future use.

Tip solutie

Permanent

Voteaza

(3 din 6 persoane apreciaza acest articol)

Despre Autor

Leave A Comment?