Skip to main content

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

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 

Labels:

Popular posts from this blog

How to Enable Hyper Terminal In Windows 7

Hyperterminal Windows 7. Windows 7 Hyperterminal. Hyper terminal is used for data communication via serial port com or TCP/IP Winsock. Unfortunately on Windows 7, Windows 8 and Windows 10 we can't see anymore, even though many of us who still need it, and it is not the solution if we have to go back to Windows XP. The solution :
Read more

Vaio stuck on loading screen after upgrading to Windows 10

My Sony Vaio laptop model : VPCCA16FB with originally using Windows 7 operating system, then now I already upgraded it to Windows 10. All drivers are already installed for each device, everything is OK with this Windows 10 OS. The only problem is:  when I switch the laptop on or restarting it, after vaio logo appears then it stuck with blank screen and it takes about 2 minutes. After that, then it continues to loading Windows. After I googling about the problem, I am not only the one, other people also have the similar problem with their laptops. The cause is in the Ultra Low Power State (ULPS) system. ULPS is a feature or mode in hardware (graphics card) designed to save power by reducing energy consumption to very low levels. Now the problem is solved. If you have the same or similar problem, maybe this below step will help you too.
Post a Comment
Read more

How to deny access to a drive in Windows 10

How to disable access to drives in Windows.  One of ways to  make disable access to drives in Windows (all Windows, Windows 10, Windows 8, Windows 7, also Windows server.. ), you can use Group policy editor . Below are  the steps: 1. Press Windows + R  (to open Run command ), write gpedit.msc at Run column, then hit Enter or click OK.
Read more