Ultimate PC optimizer: Save 30% on Auslogics BoostSpeed right now!

How to use the Split Screen function in Microsoft Excel?

By Tobenna Nnabeze | April 23, 2019 |

greater than 2 minutes

Link copied

If you are working on a large spreadsheet in Excel, it can be tedious to compare data from different sections.

Is there anything you can do to streamline the process? Definitely, there is – you can use the split-screen function.

What is the split-screen function?

The split-screen function on Excel enables you to view separate sections of a spreadsheet simultaneously. This way, you can quickly compare your data without scrolling back and forth.

How to use the split screen function in Excel?

Excel gives you complete control. You can customize the way the screen is split so as to meet your specific needs.

To access the feature, click on the View tab and select Split from the menu.

To use it, there are several options available to you:

  1. Split the screen into four equal quadrants.
  2. Split the screen vertically or horizontally.

Option 1: Split the screen into four equal quadrants

You can split your screen to create four copies of your current worksheet. All the four copies are set side by side so you can view them at the same time.

To achieve this, follow the simple process below:

  1. Go to the A1 cell and select it.
  2. Click on the View tab and select the Split option from the menu.

That’s it. Your screen will be automatically split into four worksheets.

You can make adjustments by clicking and dragging the sides of any of the worksheets or the center section.

Option 2: Split the screen vertically or horizontally

You can split the screen in half instead if you don’t require four copies of your worksheet. Depending on your preference, you can create vertical or horizontal splits.

To create horizontal splits, here’s what you have to do:

  1. Go to the A column and select any cell except A1.

    Resolve PC Issues with Auslogics BoostSpeed 11

    Besides cleaning and optimizing your PC, BoostSpeed protects privacy, diagnoses hardware issues, offers tips for boosting speed and provides 20+ tools to cover most PC maintenance and service needs.

  3. Click on the View tab and select the Split option from the menu.
  4. If you cannot resolve the
    problem yourself, you can
    ask our certified PC technicians for immediate assistance in the chat right on this page.

The split will be automatically created above the row of the selected cell. For instance, if you selected the A5 cell, the split will be between row 4 and row 5.

Creating a horizontal split is as easy as this:

  1. Go to row 1 and select a cell from any column except column A.
  2. Click on the View tab and select the Split option from the menu.

Once you have selected any cell and clicked on the Split button, the spreadsheet will be split. But you need to remember that four quadrants will be created instead of two when you choose cell A1.

How to remove the split screens?

When you are done using the function to compare sections of your spreadsheet, click on the View tab and select the Split option again to turn it off. You will have a single worksheet again.

Alternatively, you can disable the feature by dragging the split screen bars to the edge of the window.

There you have it. You’ve discovered how to make your work easy by using the split-screen function on Microsoft Excel.

It’s important to keep your PC running smoothly if you wish to complete your work without any hitch. Some users experience annoying system glitches and crashes while trying to get an important assignment done.

If you are facing such issues, use Auslogics BoostSpeed to perform a full system checkup. The tool is very user-friendly. You can schedule automatic scans to locate and eliminate junk files and any speed-reducing issues that may be causing your applications to hang. It also includes a privacy protection feature to safeguard all your sensitive personal information while you surf the web.

We hope you’ve found this content useful.

We’d love to hear your thoughts…

Feel free to drop a comment in the section below.

Fed up with your slow PC? Tired of waiting for Windows to start up? Take a look at the most common reasons behind poor performance and the best ways to deal with them here.


Call us toll-free

US & Canada 1-888-257-4137

UK 1-800-041-8199

Australia 1-800-370-543

Chat with us online

Prefer us to call you back? Give us your phone number via chat

Fix your PC in THREE easy steps

Step 1

Call us or chat with us. Our agents are online around the clock

Step 2

We will remotely access your device, provide you with free diagnostics, and discuss repair options

Step 3

Sit back and watch. Most problems will be fixed immediately within less than an hour

Watch how it works or learn more about our service here

Ad Blocker Detected

Ad blockers may interfere with some important blog features, such as comments, images, etc.

Please consider disabling your ad blocker so you can have the best experience on this website.

Got it