Generally when we open the excel file, it will show one sheet at the same time, in other words when we are seeing sheet 1 for example, we don't see the other sheets, show only sheet names at the bottom .
When we have to compare two worksheets in excel file (at the same file), we have to be able to see those two worksheets at the same time.
How to show two worksheets at the same time?
In Microsoft Excel 2007 to show two worksheets at the same time, follow these steps
• Open Excel file
• Go to the View tab
• Click New Window
• Click View Side by side
Sample figure :
Other posts :
How to Protect Ms Excel File using Password
How to Determine Character from Certain Value in Ms Excel
Simple IF function in Ms excel to makePASS or FAIL from a value
How to Resolve the problem : Couldn't Open CSV file Correctly in Ms Excel