If you have mounds of data in two spreadsheets and you need to find differences, then let me help you with that.
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.
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
Windows 11 Setup – How to upgrade your computer to the latest version of Windows
This follows on from our previous article regarding Windows 11 Update Windows 11 Setup – Windows is the world’s most…
Windows 11 Update: Everything You Need to Know
The Complete Guide to the Windows 11 Update The Windows 11 update is the latest update for the Windows operating…
Power Automate is now free with Windows 10
Published date: 08/03/2021 Power Automate is now free with Windows 10 What is Power Automate? Power Automate is a robotic…
How to share Outlook email templates
Email Templates are so useful and create consistency in the message content. I use templates when new team members join…
How to reply to a specific chat message on Teams
Published date: 03/03/2021 How to reply to a specific chat message on Teams Chat on the mobile app That’s the…
How to create an email template in Outlook
Published date: 31/03/2021 How to create and email template in Outlook Can I create a template in Outlook? Yes, you…
Disaster Recovery: How much does downtime hurt a business?
Published date: 11/03/2021 Disasters happen In the past 12 months, businesses experienced an average of 5 to 10 unplanned outages…
How to transcribe a recording made on Teams
Published date: 08/03/2021 How to transcribe a recording made on Teams Microsoft Teams Recording functionality The Microsoft Teams recording functionality…
How can you lock down a Microsoft form once live?
Published Date: 19th February 2021 How to lock down a Microsoft form to prevent it being edited Microsoft Forms Microsoft…