How to display two open excel files separately?

If you want to open two windows at the same time, click on either of them, and the windows are side by side, and that's it

You need to open one first, then open excel in the start program, and then open the one you want in the new blank.

If it's two files, yes"Taskbar"Right-click and select"Tile the window horizontally".

Open two excel programs at the same time, you can display two independent excel windows on the desktop at the same time, each window has an excel file;

If you open two excel files with one excel program, you can only display two excel file windows at the same time in one excel program window.

Don't know what the purpose of the landlord is? If the purpose is clearly stated, it should be achievable by other means.

I wonder if it's possible to make a copy of an excel** and then reopen it again and paste it on the excel program, so that the new one won't be in the same window as the original one.

In fact, it is related, you just need to pay attention to the keys on the upper right, in the outer circle (minimize, restore down, close) there is also a set inside (minimize, restore down, close), as long as you press the inside every time, there is no problem. In addition, it will not affect all the ** with the closure inside. Choose to restore down to adjust the size of the inside**,You can look side by side one one by one,If you can see it,Generally, I use two** to see together,It's messy if there's more.。

I don't know if this will help you.

Isn't it useful to modify the buttons inside? Not the outermost one.

Just "restore down" the two files separately, and restore down is "non-maximized", which is in the upper right corner of the window, and the button that minimizes, closes, and closes.

Open two Excel** sheets and click "View" in the menu bar of either one. Click "Rearrange Window", the system provides four arrangement methods, select the appropriate one, detailed steps:

1. Open two Excel** sheets, and click "View" in the menu bar of any Excel**.

2. Click "Rearrange All".

3. There are four arrangements to choose from.

4. Choose a suitable method.

Absolutely!

And it's easy to do.

It only takes 3 steps:

Views - all rearranged -

Select Tiling, Horizontal Side-by-Side, Vertical Side-by-Side, Cascade.

This is shown in the figure below.

The fly in the ointment is.

I can't take a screenshot, and the photo is not clear. Alas.

The window reflows, or the row scrollbar is pulled to separate the tables.

Window reflow.

Hope it helps.

View Reflow All Choose tiled, horizontally side-by-side, vertically side-by-side, or cascading according to your needs.

So how to make excel display separately in two windows, the operation method is as follows.

Device: Lenovo Y50

System: XP Software: Excel2016

1. First, in the computer, double-click to open the document.

2. Document 1 is displayed in green.

3. Document 2 is shown in orange, which is used as an example to demonstrate.

4. Click on the view option above one of the documents.

5. Click Rearrange All in the window options interface.

6. In the pop-up dialog box, select the arrangement method and click OK.

7. In this way, you can see that excel is displayed separately in the two windows.

1. First of all, click the "File" option in the upper left corner of the open excel**, and select "Tools" in the pop-up options.

2. Then click the "Options" button in the "Tools" options menu that opens.

3. You can open the "View" dialog box, and click the "View" option in the menu bar on the left.

4. After entering the "View" window, select the checkbox in front of "Show all windows in taskbar" and click OK to display all documents separately.

Open two Excel** sheets and click "View" in the menu bar of either one. Click "Rearrange Window", the system provides four arrangement methods, select the appropriate one, detailed steps:

1. Open two Excel** sheets, and click "View" in the menu bar of any Excel**.

2. Click "Rearrange All".

3. There are four arrangements to choose from.

4. Choose a suitable method.

Take Office 2016 as an example.

1. Select and open the "Excel" software in the Windows system.

2. In the open "excel" software, select the "Hit Chi Kai Call" button in the list on the left.

3. In the pop-up "excel" open list, select two excel** boxes and open them.

4. After opening Sun Ran, I found that only one ** was displayed.

5. You need to select the "View" button in the options bar above.

6. After selecting "Rearrange All" at the bottom of the "View" button, two excel** windows will be displayed at the same time.

Open two excel files at the same time and want to display them in the same form, the specific operation process is as follows:

1. The first step is to open the two files you need in Excel at the same time, and then select [View] above the toolbar, as shown in the figure below.

2. In the second step, select [Rearrange All] - Vertical Side-by-Side], as shown in the following figure.

3. In the third step, after selecting vertical side by side, you can see two ** side by side in the window, as shown in the figure below.

4. The fourth step, after side by side, the default small window opens, if you want a ** to cover the screen, click the full-screen logo in the upper right corner, as shown in the figure below.

Preparation Tools Materials: A computer with Windows 10, Microsoft Office Home and Student Dust Harvest 2016 Excel software.

1. First of all, open all the macro excel files that need to be viewed side by side.

2. Select any excel file, and click View in the interface that appears.

3. Then select Side-by-side view on the right side.