• Split View In Excel For Mac Shortcut
• Split View In Excel For Macs

Last week I introduced you to Synchronous Scrolling in Microsoft Word while viewing two documents. As promised, this week’s post will focus on performing that task in Microsoft Excel.

How to use the split-screen feature on a Mac computer How to properly uninstall programs on Windows 10, to protect your computer and free up space Insider Inc. Receives a commission when you buy. Excel splits the window at that column and adds a second horizontal scroll bar to the new pane. Instead of dragging split bars, you can divide a worksheet window by clicking the Split button on the View tab. Excel uses the position of the cell cursor to determine where to split the window into panes.

View two worksheets in the same workbook side by side

On the View tab, in the Window group, click New Window.

On the View tab, in the Window group, click View Side by Side.

In the workbook window, click the worksheets that you want to compare.

Split View In Excel For Mac Shortcut

To scroll both worksheets at the same time, click Synchronous Scrolling in the Window group on the View tab.

View two worksheets of different workbooks side by side

Open both of the workbooks that contain the worksheets that you want to compare. Note: One workbook will be displayed and the other workbook will be minimized until the next step.

On the View tab, in the Window group, click View Side by Side.

In each workbook window, click the sheet that you want to compare.

To scroll both worksheets at the same time, click Synchronous Scrolling in the Window group on the View tab.

NOTE: This option is available only when View Side by Side is turned on.

If you have a tip that you would like to share, please feel free to email your suggestion to the Hotline. It may appear in a future edition of Tech Savvy Tuesday. To email your suggestion to the Hotline, just open a new message and type Hotline in the To Field.

Split screen mode is a handy feature that divides your screen into two windows (not necessarily the same size), allowing you to work on two different things or use two different apps at the same time. It is convenient if you’re working on research projects or work assignments that require multiple programs or apps. The good news is, it is straightforward to do a split screen on Mac. This article will show you the steps on how to use split view on Mac and the things you can do with a split screen.

Requirements

To be able to do a Mac split screen, you should have MacOS El Capitan installed, at the very least. You have to take note though that not all apps work with the split view. You’ll understand once you’ve read this tutorial and tried it for yourself. You’ll notice that some apps will go to full screen and refuse to split no matter what you do. It is possible for third-party apps like Microsoft Office apps. However, most Apple-sponsored apps support Mac screen split.

How to Use Split View on Mac

• Before you start, open the Mac windows or apps that you want to view side by side. You can open any app, browser, documents, etc., except those that can’t do Mac split screen.
• Choose one screen and look at the upper-left corner where you’ll see the red, yellow and green buttons. The red button closes the window, the yellow button minimizes it, while the green button can either maximize the window or switch to split screen.
• Hold down the green button so that the window will resize, and then drag it to one half of your screen. Do not click the green button because it will maximize the window instead of resizing it.
• Now, your Mac screen split is half-done. The next step is to choose the second window you want to open on the other half. Just hold down the green button again and drag it to the empty half of the screen, where it will automatically shift to cover the unoccupied space.

How to Adjust Mac Split Screen

Your Mac split screen doesn’t need to be precisely half and a half. You can choose which window gets a more significant share of the screen. What you need to do is look for the thin black line separating the two windows and hold that line. Move the line to the left or the right, depending on which window you want to give more screen. It can be handy if you need to see the details of the other screen or you need extra space to see more information.

Click the chosen window and hold one of them and drag it over to the other side, if you want to switch the position of the windows. The separate window will automatically move to the recently vacated window.

Adjust the screen resolution to make it look better if the window looks big or small. If you want to leave the Mac screen split mode, click the green button on any of the windows. It will return the windows to their original size and position before you started the Mac split screen.

There are so much you can do with a split screen. For example, you can open a document window while having Safari open on the other half of the screen for research purposes. Or, you can have an image open on the other side while you have Finder open at the same time.

Mac split screen can be a bit taxing on your computer though, especially if you have more than two windows open and you don’t have sufficient storage and RAM space. To ensure you have a smooth split view experience, boost your Mac’s performance with Tweakbit MacRepair. This app scans your computer for junk files and deletes them while pinpointing issues that could affect your Mac’s performance.

Split View In Excel For Macs