To make two excel files appear side by side at the same time, you can use the following two methods:
Method 1: Use Excel's "Side-by-Side View" function.
Open the first excel file.
Open the second excel file.
On the menu bar of any Excel window, click the View tab.
In the View tab, find the Windows group and click the View Side by Side button.
Excel will automatically display the two files side by side, and you can adjust the width between the two files by dragging the divider.
Method 2: Use the "Split Screen" feature of Windows.
Open the first excel file.
Open the second excel file.
Move the mouse pointer over the thumbnail of the first excel file on the taskbar and right-click.
In the menu that pops up, select "Show windows side by side" or similar. The specific option names may vary depending on the version of Windows.
Windows will display two Excel files side by side on the screen, and you can adjust the width between the two files by dragging the divider.
The above are two commonly used ways to achieve side-by-side display of two excel files at the same time. These two methods are explained and introduced in detail below.
Method 1: Use Excel's "Side-by-Side View" function.
Excel's "View Side-by-Side" feature is a very convenient way to view and edit two files at the same time. This feature allows you to display the contents of two files side by side in the same excel window, allowing you to easily switch and compare between the two files.
To use the "View Side-by-Side" feature, you need to open two Excel files and click on the "View" tab on the menu bar of either file. In the View tab, find the Windows group and click the View Side by Side button. Once you click on this button, Excel will automatically display the two files side by side on the screen.
In side-by-side viewing mode, you can adjust the width between two files by dragging the divider for better viewing and editing. In addition, you can use synchronous scrolling so that when you scroll one of the files, the other file will scroll accordingly, keeping the two files aligned.
Method 2: Use the "Split Screen" feature of Windows.
In addition to using Excel's "side-by-side view" feature, you can also take advantage of the "split screen" feature of the Windows operating system to display two Excel files side-by-side at the same time. This feature allows you to divide your screen into multiple areas, each of which displays a different app or file.
To use the Windows "Split Screen" feature, you need to open two Excel files first, then move your mouse pointer over the thumbnail of the first Excel file on the taskbar and right-click. In the menu that pops up, select "Show windows side by side" or similar. The specific option names may vary depending on the version of Windows.
Once you have selected the "Show windows side by side" option, Windows will display the two Excel files side by side on your screen. You can adjust the width between the two files by dragging the divider to better fit your screen size and resolution.
It should be noted that the "split screen" feature of Windows may vary depending on different Windows versions. In some newer versions of Windows, you may need to use different gestures or shortcuts to trigger the split-screen feature. Therefore, it is a good idea to consult the help documentation or resources of the version of Windows you are using to understand the specific steps and requirements before using them.
Whether you use Excel's "View Side-by-Side" feature or Windows' "Split Screen" feature, it allows you to conveniently view and edit two Excel files at the same time. Both methods have their own advantages and disadvantages, and you can choose the one that suits you according to your needs and Xi. For example, if you only need to do an occasional side-by-side view, it may be more convenient to use Excel's "side-by-side view" feature; And if you often need to work on multiple files and applications at the same time, then using Windows' "split screen" feature may be more practical.