How to open two independent windows in Excel? How to open excel windows independently without overlapping

php editor Apple introduces you how to open two independent windows in Excel. In daily work, sometimes you need to view different Excel tables at the same time, but Excel can only open multiple tables in the same window by default, causing visual confusion. If you want to achieve the effect of non-overlapping display of two independent windows, you can achieve it with simple operations. Next, we will introduce in detail how to implement this function.

How to open two independent windows in Excel?

1. Like Word, you can open two independent windows, as shown in the figure below. The specific operations are as follows.

2. First open the run of the start menu, enter regedit, and open the registry, as shown in the figure below.

3. After opening the registry, locate HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\Open. There is a lot of content and you can quickly search it in alphabetical order.

4. You can make a backup before modifying it. After you find it, click it and select command first. Default and command will appear on the right side. Double-click the default. As shown in the figure below, modify the trailing /e to "%1" and click OK.

5. Then, double-click the command, modify the tail value to "%1", and then confirm. As shown below.

6. After modification, modify the ddeexec file name under Open, which can be changed to ddeexec2. As shown below.

7. After modifying Excel.Sheet.12shellOpen, modify Excel.Sheet.8shellOpen under Excel.Sheet.12. The modification method is the same as above. After making the same modifications. Open two more Excels and you will find that they can be dragged apart to display two independent windows.

The above is the detailed content of How to open two independent windows in Excel? How to open excel windows independently without overlapping. For more information, please follow other related articles on the PHP Chinese website!