How to Find the Difference Between Sheets in Open Office


The spreadsheet program, Calc, includes a variety of useful functions. For example, the track changes feature lets you accept or reject changes made to your spreadsheet by someone else. But what if you forget to turn track changes on for your sheet? Comparing two large sheets to find the changes would be tedious. Fortunately, Calc includes a document comparison tool designed for this type of situation. The tool requires the original and modified versions of the document to work.

  • Double-click the modified document to open it, or if Calc is running, click the "Open" option in the "File" menu to open the modified document. Click the "Compare Document" option in the "Edit" menu.

  • Browse to the location of the original document in the window that appears, then click "Open." A window appears with a list of changes made to the document. The first column shows the action or type of change, the last column specifies exactly what was changed.

  • Click the first change displayed on the list. The row and affected cell or cells are highlighted on the sheet.

  • Click the "Accept" button to accept the change and continue, or click the "Reject" button to restore the original contents of the cell. The next entry is automatically highlighted after you click "Accept" or "Reject."

  • Continue reviewing each entry to finish comparing the modified document. Close the "Accept or Reject Changes" window after reviewing all the modifications. Save your document to keep the changes.


Promoted By Zergnet


You May Also Like

Related Searches

Is DIY in your DNA? Become part of our maker community.
Submit Your Work!