How To Put Two Excel Windows Side By Side

This is a real time-saver: You tin can see the same Excel file side by side in 2 windows. Of course, this works also for different Excel files. And the best: It does not only work for Microsoft Excel, but for all other Part programs, such as PowerPoint, Word or Outlook. Hither is how to exercise that with just two clicks!

Contents

See the same file in two windows
Scroll both windows at the same time: Enable or disable synchronous scrolling
See two different files adjacent
Mac users: Show Excel file in two windows next nether macOS
- Also interesting:

Encounter the same file in two windows

To exist honest, this button is not very subconscious. But nonetheless, about Excel or Office users have never tried it out. In my Excel trainings, fifty-fifty advanced users acknowledge that they have never heard of it – and happily incorporate information technology into their daily routines.

So, how does it work? Simply get to the View ribbon and click on New Window:

First step: Click on New Window in order to see a file side by side. — First step: Click on New Window in guild to meet a file side by side.

Now, the Excel file is open in two windows. You can also see that past the small number 1 and 2 (or even more) in the top of the Excel window, next to the file names.

Next, we conform the two windows next to each other: you have multiple different options, but the fastest is to click on "View next" on the View ribbon.

Second step: Click on "View Side by Side". — Second footstep: Click on "View Side by side".

It should wait like to this:

The best: This does not just work with Excel. Also, PowerPoint, Word, Outlook and even OneNote take the aforementioned feature.

Instead of arranging windows vertically next to each other, you can also show them horizontally or - in case of more than two windows - see them "tiled". — Instead of arranging windows vertically next to each other, you lot tin also prove them horizontally or – in instance of more two windows – see them "tiled".

Do yous desire to change the organisation, for example ii windows on top of each other? Excel has the "Arrange All" office. Click on it on the View ribbon and you lot will run across the window on the correct.

Curl both windows at the same time: Enable or disable synchronous scrolling

When you take bundled the Excel windows as shown above, you can even curlicue both windows at the same time. By default, this pick is activated when y'all click on "View Side by Side".

Again, on the View ribbon, click on "Synchronous Scrolling" for enabling or disabling it:

Comparting two worksheets or files? Use the Synchronous Scrolling function in Excel. — Comparting ii worksheets or files? Use the Synchronous Scrolling office in Excel.

See two unlike files adjacent

This is even easier: See two different files next to each other. Just employ the same built-in Excel feature.

On the View ribbon click on "View Side by Side".

If you want to reset or change the organization, click on Arrange All.

Practise you lot want to heave your productivity in Excel?

Get the Professor Excel ribbon!

Add more than 120 nifty features to Excel!

Mac users: Show Excel file in two windows side by side under macOS

The good news: It works very similarly on a Mac computer. As shown above, start display the file in two windows.

For arranging the two windows you also have two options: Either use the "Arrange All" function (works the same style as nether windows, described above).

Arrange windows side by side in macOS. — Conform windows side by side in macOS.

Or arrange the with the Zoom function, provided by macOS:

Click and concur the mouse downward until the context card as shown on the correct opens. Then, click on "Tile Window to Left of Screen" and exercise the same to the right with the 2nd window.

Image by StockSnap from Pixabay

Henrik Schiffner is a freelance business consultant and software programmer. He lives and works in Hamburg, Frg. Likewise being an Excel enthusiast he loves photography and sports.

Source: https://professor-excel.com/how-to-see-an-excel-file-in-two-windows-side-by-side/

Posted by: ramseythipper82.blogspot.com