How to compare two versions of an excel workbook

5 min read

If you have mounds of data in two spreadsheets and you need to find differences, then let me help you with that.

Add Inquire to your Excel command ribbon

  • Open any excel spreadsheet
  • Click File > Options > Add-Ins.
  • Select COM Add-ins in the Manage box, and click Go.
  • Check the box next to Inquiry Add-in when the COM Add-Ins box is selected. The Inquire tab in Excel will appear after the add-in has been turned on.

NB:  You need to have Microsoft Office Professional Plus 2013 or above installed on your computer because it won’t be available if not.  If you do have the correct version, then speak to your Company system administrator to make it available.

Compare Spreadsheets

  • Open the spreadsheets you want to compare
  • At the Inquire tab (in the ribbon) select compare files
  • Compare the earlier file to the later file


Understanding the results

In the side-by-side grid, cells with “entered values” (non-formula cells) are formatted with a green fill color, and in the pane result list with green font so this is easier to read. The lower-left pane is a legend that shows what the colours mean.

You can select what you want to see by clicking the Enable button.

Export the results at Home > Export Results to create an excel spreadsheet that shows the old and new values


Do you need the best IT Support and Maintenance for your business?

You need the best IT support in London. Technology is complicated and expensive. It’s so hard to maintain everything and know what to do when something breaks or goes wrong. IT problems can put a damper on your day. They’re frustrating, time-consuming, and seem like a never-ending cycle of issues.

Why you should choose Penntech IT Solutions

Customer Satisfaction Levels/NPS Score

Penntech’s average NPS score over 90 days is 84. The average Net Promoter Score (NPS) for IT Managed Service Providers (MSPs) can vary. Still, an NPS of around 50 is considered excellent in this industry, with scores above 70 exceptional and rare.

No lengthy contract tie-ins and a trial period

We offer our services on a trial basis for the first three months because we’re confident in our delivery and approach.

Comprehensive 24/7 IT Support

Penntech offers a wide range of IT services, from strategic project management to 24/7 remote support, ensuring all your IT needs are always covered.

Cybersecurity Expertise

We provide advanced cybersecurity measures and expertise, including penetration testing services and Cyber Essentials, to protect clients from cyber threats.

Scalability

We offer Clients the ability to scale IT services up or down based on their needs. This flexibility is crucial for businesses that experience seasonal changes or rapid growth.

Tech Focus, not Sales Focus

Other providers often enforce their preferred IT stack, but we don’t, as IT is not a one-size-fits-all solution.

Disaster Recovery and Backup Solutions

We ensure our Clients’ business continuity through robust disaster recovery and backup solutions.

Expertise Across Industries

With experience in various verticals and industries, Penntech understands different businesses’ unique IT challenges and can provide customised solutions..

Contact us today or explore the range of support packages on offer.

Related news

View all News

Menu