How do I have 2 Excel files open side by side?

How do I have 2 Excel files open side by side?

How to view two Excel sheets side by side

1. On the View tab, in the Window group, click New Window. This will open another window of the same workbook.
2. On the View tab, in the Window group, click View Side by Side.
3. In each window, click the desired sheet tab. Done!

Can I open 2 separate Excel Windows?

You can open the Excel application multiple times to have a couple of Excel windows on the desktop. To do that, click the Excel icon to open the software. Then click Excel’s icon again to open the software for a second time. Thereafter, you’ll have two Excel windows on the desktop.

How do I get Excel to show horizontally side by side?

On the View tab, in the Window group, click Arrange All.

1. Select the desired arrange setting. For example, click Horizontal.
2. Click OK.
3. On the View tab, in the Window group, click View Side by Side (by default, Synchronous Scrolling is activated), to scroll both workbooks at the same time.

Why can’t I open two Excel files at once?

The solution is to change how you are starting Excel. Instead of double-clicking on one of the workbooks in the selection set, right-click on one of the files and choose Open. The selection set remains intact and all the files are opened in Excel, as desired.

How do I separate two Excel Windows?

Split a sheet into panes

1. Select below the row where you want the split, or the column to the right of where you want the split.
2. On the View tab, in the Window group, click Split. To remove the split panes, click Split again.

How do I open two Excel files with the same name?

Try this:

1. On your Desktop right click and choose “New” => “Microsoft Excel worksheet”.
2. Rename the file to “Test[1]. xlsx” (the name is important!)
3. Now create a now folder on the desktop and paste a copy of the file “Test[1]. xlsx” into it.
4. Open both “Test[1]. xlsx” via double click: Et voilà!