Answer :
Answer:
By using various tools.
Explanation:
You can compare excel files and data using different tools which are available online and even in your local files. Listed below are the ways and procedure for you to compare data in excel:
1. By using Microsoft Word
Procedure :
1.1 Select cells with the data that you want to compare. Copy them or simply press Ctrl key and C key and paste in on a blank word document. Remember to select only the data that you need to compare not the whole worksheet at it may cause the document to load slower.
1.2 You should have two files. Old.doc which contains the old documents and New.doc which contains the changes that you have made on the previous document.
1.3 Using Microsoft Word, Go to Tools, then Track Changes then select Compare documents.
1.4 You can now view the changes from the old to new document
2. Using Microsoft Excel itself
Procedure:
2.1 Paste the old texts and contents in Cell A1.
2.2 Paste the new texts and contents in Cell B1.
2.3 In Cell C1, use the formula =IF(A1=B1,"","!")
2.4 Double click on the ,,+" when t shows in cell C1
2.5 You can now see the two different versions of the texts.
3. You can use online tools which are available via search engines.
Answer:
use page layout view to break the worksheet into different visible sections
Explanation:
plato