Tips For Split Screen In Windows & Mac - Excel Campus

Bottom line: Learn how to enable split screen view in Windows & Mac. I share time saving tips and keyboard shortcuts for working in multiple windows.

Skill level: Beginner

Work With Multiple Windows in Split Screen

When working with Excel (and other Office applications) we typically need to perform actions between two files. This can include copy/paste, writing formulas, tying out numbers between reports & data, etc.

The split screen view in both Windows & Mac allows us to view and interact with multiple windows at the same time. Of course we could resize the windows manually to achieve this effect, but both operating systems have features that make split screen easy to enable.

So let's take a look at those features.

Split Screen View for Windows

Windows allows us to enable split screen view with both the mouse and keyboard shortcuts.

Split Screen with the Mouse in Windows

To split the screen we can simply drag a Window to the left or right side of the screen. Here are the instructions:

1. Left-click and hold on the title bar of the window and drag it to the right/left edge of the screen in the middle.
2. You will see a faint outline of a box take up half the screen.
3. Release the left mouse button.
4. On the opposite side of the screen you will see all the open windows displayed in tiles.
5. Click any tile to maximize that window into the other side of the screen.
6. This creates a vertical split of both windows.

Split Screen with Keyboard Shortcuts in Windows

Windows also gives us keyboard shortcuts to split the screen.

1. At any time you can press Win + Left/Right Arrow to move the active window to the left or right.
2. Release the Windows button to see the tiles on the opposite side.
3. You can use the tab or arrow keys to highlight a tile,
4. Press Enter to select it. You can also use the mouse to select it.

The Windows key is located on the left side of the space bar, typically between the Ctrl & Alt keys.

What If Split Screen Doesn't Work?

Sometimes you will move a window to one side (with the mouse or keyboard shortcut) and the tiles won't appear on the opposite side.

This happens when there is already a window on that opposite side that is in split screen.

There are a few ways to fix this:

Minimize All But Active Window

The keyboard shortcut Win+Home will minimize all windows except for the active window. You can then use the mouse or keyboard shortcut to split the screen.

Minimize the Other Window

Another option is to just minimize the window on the opposite side. This usually works unless you have another split window behind it.

Show the Desktop & Start Over

If you forget the Win+Home shortcut, you can also use this technique to minimize windows.

To show the Desktop, press Win+D or left-click the bottom right corner of the screen.

Then open one of the windows you want to split and use the mouse or keyboard shortcut to split it.

Split Screen View for Mac

On a Mac we can also achieve split screen view with the mouse. I don't know of any keyboard shortcuts for this, but please leave a comment below if you figure it out.

To enable split screen on the Mac:

1. Left-click and hold the Full Screen (green) button in the top-left corner of a window.
2. You have to hold the mouse button for about a second.
3. The window will then resize and you should see a shaded box over the right or left half of the screen.
4. Drag the window to the right or left side and release the mouse button.
5. All open windows will be displayed on the opposite side in tiles.
6. Select a tile to maximize the window on the opposite half of the screen.

How to Get Out of Split Screen on Mac

One interesting thing to note is that both of the split windows get put into full screen mode. If you take one window out of full screen, the other will still remain in full screen.

1. One quick way to get both windows out of full screen is to enable Mission Control (three finger swipe up on track pad or dedicated key (usually F3)).
2. You will see the new split window as a Space on the top bar.
3. Drag the space into the bottom half of the screen to remove the split and return the windows back to their original sizes.
4. Click one of the windows to view it on the desktop.

There are other ways to do this, so feel free to leave a comment below if you have a faster way. I'm not an everyday Mac user…

Working with Files & Folders

It's the beginning of the year and that might mean it's time to organize files and folders. We can use split screen view with File Explorer (Windows) or Finder (Mac) to quickly move/copy files between folders.

Holding the Ctrl key while dragging a file to a new folder will make a copy of the file, instead of moving it.

Bonus Tip on Debugging Macros in Split View

In the video above I share a tip for using split screen to debug and step through VBA code. This allows us to see the changes that are made to the Excel file as the code is running.

I use this setup all the time and it's a great way to test, debug, and learn VBA code. It was actually the inspiration for this post, but there a TON of uses for split screen view.

I explain more about writing, testing, and stepping through code in my free upcoming webinar on The 7 Steps to Getting Started with Macros & VBA.

What Else Can We Do with Split Screen?

Split screen is definitely a handy feature for Windows or Mac. There are infinite uses for it, and it can definitely save time when working in multiple windows or applications.

Do you have any other suggestions or techniques you use? If so, please leave a comment below. It will be great to learn some time saving tips from everyone.

Thank you and Happy New Year! 🙂