How To Open Two Windows In Excel

Table of contents:

How To Open Two Windows In Excel
How To Open Two Windows In Excel

Video: How To Open Two Windows In Excel

Video: How To Open Two Windows In Excel
Video: How to open and view 2 Excel workbooks at the same time 2024, March
Anonim

Excel is one of the most demanded software. Some users may need to work with several windows in the program at once, but this cannot be done with the standard settings.

How to open two windows in Excel
How to open two windows in Excel

Microsoft Excel

Microsoft Excel is one of the most convenient programs for working with tables and graphs. It has huge functionality, which you first need to figure out in order to do everything efficiently. To work with Microsoft Excel, it is not necessary to enter macros or formulas all the time, since the program has an instant fill function. This means that you can enter any formula or macro at least once and the program will remember it and on this basis you can calculate the remaining data. With the help of a pivot table, Microsoft Excel allows you to perform even the most complex mathematical calculations very quickly. In addition to all of the above, Microsoft Excel can build a diagram necessary for the user (which can be changed), perform express analysis, etc.

Opening multiple windows in Microsoft Excel

To work with Microsoft Excel, you need to have minimal mathematical knowledge in order to compose your own formulas and perform other manipulations. The program can do the rest on its own. Unfortunately, like most programs, it can be difficult to fully understand the program. For example, some users may need to have Microsoft Excel open documents in two windows at once. This feature allows you to perform calculations, analyze data, etc. much faster. Unfortunately, not everyone knows about such a function, and even if they do, they cannot activate it.

Basically, it's pretty easy to open documents in two windows in Excel. To do this, you need to start the Microsoft Excel program itself and find the "Window" tab. Further, in the list that appears, you need to find the line "Arrange" and click on it. After that, the user will be asked to choose one of four options for the arrangement of windows. It is worth noting one significant nuance, which is that such a function is available only in Microsoft Excel 2007 and Microsoft Excel 2010, and in previous versions of the program it is not.

If you have Microsoft Excel 2003 (or later versions) installed, you can simply click on the "Minimize to window" button after opening the program (located next to the cross in the upper right corner of the window). After that, you need to open another document and do the same. Next, you need to adjust the size of the windows (move the mouse cursor over the window border and, while holding the left mouse button, drag to the optimal size).

Recommended: