Sunday, October 14, 2012

How to Open Two Worksheets At The Same Time In Excel 2007

Tags

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 


Artikel Terkait