![]() However, in my case, I want to compare the data simultaneously, throughout the Excel files. This is very time-consuming unless your data comparison requires static view. Usually, in the first GoogleStock file window, you would scroll where you want and then go to the next file and do the same. ![]() Now, let us say you want to compare the data of both of these files. As you can see, the row column is highlighted in orange. The active window is a GoogleStock.csv file. Here, I have opted to view them horizontally. ![]() Choose the view that best suits your needs. Then go to View and click View Side by Side which will give you an option to view both Excel files in horizontal, vertical, cascade, etc. ![]() In this example, there are two Excel files in which I will compare the data. Fortunately, Excel includes some powerful features that, when used in combination, will save time and make your job easier. When you have a large collection of data in an Excel spreadsheet, you may find you need a simple method for manipulating the data or for comparing the data to that of another spreadsheet.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |