Free Excel Tutorial for Engineers : Vide Options

Comparing 2 or more excel worksheets is made easy by the view side by side option in excel. If you have 2 or more excel files open, you don’t have to toggle between the files to compare the document. All you have to do is go to the view ribbon, select the view side by side option and all the excel worksheets currently open will be displayed in one screen. The synchronous scrolling will be automatically activated by excel which scrolls through all the documents together. By deselecting this option you can scroll through one document while keeping the other worksheets as reference.

14.png