Categories
Device

How to use excel’s split screen function

How to use excel’s split screen function

Splitting screens, whether vertically or horizontally, is a great way to streamline your workflow when using Excel. Using this feature lets you simultaneously view separate sections of a spreadsheet, enabling you to compare data quickly. Here’s how.

Using the Split Screen Function

If you have a spreadsheet packed with data, navigating it can be quite cumbersome, especially if you want to compare data from several different sections of the spreadsheet. Taking advantage of Excel’s split-screen functionality can streamline this process. Excel also lets you customize how the screen is split, giving you complete control for your specific needs.

Finding the split screen function is easy enough. Just head over to the “View” tab and click the “Split” option.

That said, there are a few ways to use this feature to split the screen.

Creating Four Equal Quadrants

Excel lets you split the screen into four equal quadrants. This gives you four copies of your current worksheet, all on the same screen! To do this, first, make sure that you’ve got the A1 cell selected.

Next, head back over to the “View” tab and click the “Split” button. This will split your screen into four equal worksheets.

You can also tweak where the split is by clicking and dragging either side of one of the worksheets, or the center section.

How to use excel’s split screen function

Vertical and Horizontal Splits

If you don’t need four copies of the worksheet, you can split the screen in two instead. You can split the screen horizontally or vertically, depending on what you need.

To split the screen horizontally, select a cell from column A in any row (Except for the A1 cell). Next, click the “Split” button on the “View” tab. The split will appear above the selected row. For example, if we select cell A5, the split will look like this:

Splitting the screen vertically is just as easy. Select a cell from any column (except column A) in row 1 and click the “Split” button.

You don’t have to follow these rules exactly. Selecting any cell from any row will split the spreadsheet. The only thing to remember is that, unless you select a cell from the first row or from column A, the screen will be split into four instead of two.

Once you’re finished with the feature and are ready to get the screen back to a single worksheet, simply click the “Split” option again to turn it off. Alternatively, you can drag the sides of the split screen bars to the edge of the window to disable the feature.

How to use excel’s split screen function

Resolve PC Issues with Auslogics BoostSpeed

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.

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.
  2. Click on the View tab and select the Split option from the menu.

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.

How to use excel’s split screen function

Splitting screens, whether vertically or horizontally, is a great way to streamline your workflow when using Excel. Using this feature lets you simultaneously view separate sections of a spreadsheet, enabling you to compare data quickly. Here’s how.

Using the Split Screen Function

If you have a spreadsheet packed with data, navigating it can be quite cumbersome, especially if you want to compare data from several different sections of the spreadsheet. Taking advantage of Excel’s split-screen functionality can streamline this process. Excel also lets you customize how the screen is split, giving you complete control for your specific needs.

Finding the split screen function is easy enough. Just head over to the “View” tab and click the “Split” option.

How to use excel’s split screen function

That said, there are a few ways to use this feature to split the screen.

Creating Four Equal Quadrants

Excel lets you split the screen into four equal quadrants. This gives you four copies of your current worksheet, all on the same screen! To do this, first, make sure that you’ve got the A1 cell selected.

How to use excel’s split screen function

Next, head back over to the “View” tab and click the “Split” button. This will split your screen into four equal worksheets.

How to use excel’s split screen function

You can also tweak where the split is by clicking and dragging either side of one of the worksheets, or the center section.

How to use excel’s split screen function

Vertical and Horizontal Splits

If you don’t need four copies of the worksheet, you can split the screen in two instead. You can split the screen horizontally or vertically, depending on what you need.

To split the screen horizontally, select a cell from column A in any row (Except for the A1 cell). Next, click the “Split” button on the “View” tab. The split will appear above the selected row. For example, if we select cell A5, the split will look like this:

Splitting the screen vertically is just as easy. Select a cell from any column (except column A) in row 1 and click the “Split” button.

How to use excel’s split screen function

You don’t have to follow these rules exactly. Selecting any cell from any row will split the spreadsheet. The only thing to remember is that, unless you select a cell from the first row or from column A, the screen will be split into four instead of two.

How to use excel’s split screen function

Once you’re finished with the feature and are ready to get the screen back to a single worksheet, simply click the “Split” option again to turn it off. Alternatively, you can drag the sides of the split screen bars to the edge of the window to disable the feature.

@Marshall_G08
Apr 22, 2019, 10:24 am EST | 1 min read

How to use excel’s split screen function

Splitting screens, whether vertically or horizontally, is a great way to streamline your workflow when using Excel. Using this feature lets you simultaneously view separate sections of a spreadsheet, enabling you to compare data quickly. Here’s how.

Using the Split Screen Function

If you have a spreadsheet packed with data, navigating it can be quite cumbersome, especially if you want to compare data from several different sections of the spreadsheet. Taking advantage of Excel’s split-screen functionality can streamline this process. Excel also lets you customize how the screen is split, giving you complete control for your specific needs.

Finding the split screen function is easy enough. Just head over to the “View” tab and click the “Split” option.

How to use excel’s split screen function

That said, there are a few ways to use this feature to split the screen.

Creating Four Equal Quadrants

Excel lets you split the screen into four equal quadrants. This gives you four copies of your current worksheet, all on the same screen! To do this, first, make sure that you’ve got the A1 cell selected.

How to use excel’s split screen function

Next, head back over to the “View” tab and click the “Split” button. This will split your screen into four equal worksheets.

How to use excel’s split screen function

You can also tweak where the split is by clicking and dragging either side of one of the worksheets, or the center section.

How to use excel’s split screen function

Vertical and Horizontal Splits

If you don’t need four copies of the worksheet, you can split the screen in two instead. You can split the screen horizontally or vertically, depending on what you need.

To split the screen horizontally, select a cell from column A in any row (Except for the A1 cell). Next, click the “Split” button on the “View” tab. The split will appear above the selected row. For example, if we select cell A5, the split will look like this:

How to use excel’s split screen function

Splitting the screen vertically is just as easy. Select a cell from any column (except column A) in row 1 and click the “Split” button.

How to use excel’s split screen function

You don’t have to follow these rules exactly. Selecting any cell from any row will split the spreadsheet. The only thing to remember is that, unless you select a cell from the first row or from column A, the screen will be split into four instead of two.

How to use excel’s split screen function

Once you’re finished with the feature and are ready to get the screen back to a single worksheet, simply click the “Split” option again to turn it off. Alternatively, you can drag the sides of the split screen bars to the edge of the window to disable the feature.

The split-screen function in Microsoft Excel allows you to compare data on the same work sheet. You can split a worksheet into two or four panes depending on the data you would like to analyze. The details of the complete worksheet are visible on each pane that you split.

Also, you can highlight the sections to compare on the individual panes. It is possible with both horizontal and vertical ways to use the split-screen function in Microsoft Excel. This will help streamline your task sheets easily. Let us see how to use this function now.

Also Read: Best Alternatives to Microsoft Visio Drawing Tool

How Does The Split Screen Function Work?

Using the split-screen function in Microsoft Excel is a simple process. You only have to follow a few steps to learn and do it successfully.

  • Click on the WindowsStart button and open Microsoft Excel.
  • To open the MS-Excel tool, either type Excel in the Windows search bar or search it from AllPrograms.
  • Go to the File menu and choose Open in the Excel sheet that you have opened.
  • Double-click on the file that contains data for comparison and you require the Split screen function to be enabled.
  • After the file is opened and the data is loaded completely, click on the View tab and look for the Split
  • The next step is to split the worksheet into four panes. To do this, select the A1 cell at first.
  • Now get back to the View tab and click on the Split option again.
  • With this, your worksheet splits into four panes which are changeable in positions. You can easily select and move the pointer of any split-screen column and alter their position. This will ensure a better presentation of worksheets during comparison.

Horizontal Split Screen in Ms. Excel

If you require only two copies of your worksheet, then you can split the screen horizontally. Follow these quick steps to split the excel worksheet into two:

  • Leaving A1, select a cell in any row in the column A.
  • Go to the View tab and click on Split. Now the split-screen appears above the tab that you have selected for the split.
  • The horizontal split screen process is complete now.

Vertical Split Screen in Ms. Excel

  • Leave the column A and select a cell from any column in row 1. Your worksheet is now split vertically.
  • You need not use the Split option under the View tab here. When you click split-screen for the first time, it happens only vertically.

How to Turn Off the Split Screen Function in Microsoft Excel?

  • Once you finish comparisons and other tasks using the SplitScreenfunctioninMicrosoftExcel, first save your changes.
  • Go to the View tab and click on the Split This will turn off the option.
  • You can also make it disappear by dragging the cell column pointer towards the end of the sheet.

How To Split Screen in Microsoft Excel 2003?

Latest versions of Microsoft Excel from 2010 have the split option to easily split screens accordingly. But earlier versions have different ways of doing it.

  • Open the Microsoft Excel 2003 file that contains data.
  • Make sure that your sheet contains enough rows and columns filled with data.
  • From whichever column you wish to select, click the entire column and select it.
  • Go to the Window menu available next to Data and click on the Split
  • This is for splitting the worksheet vertically.

To use the split-screen in Ms Excel 2003 horizontally, follow these quick steps:

  • Select the row that you wish to split the screen from. Identify the horizontal bar at the right end of the sheet.
  • Now, click on the arrow that appears on the bar and the horizontal split-screen happens automatically.
  • To remove the split-screen, you can simply click on the pointer line that splits the screen.
  • Otherwise, go to the Window menu and choose the RemoveSplit option to turn it off.

Due to changing versions of the Windows operating system, you might find the Split Screen option available under the different menu. But the implementing method of Ms. Excel screen can be spat and remains the same. Please note that MS Excel versions do not change as per Windows OS version upgrade.

Bottom Line

I hope this blog was informative and you learned a piece of knowledge out of it. Microsoft Excel comes with immense formulas and options for usage. It supports not only streamlining your processes but also your business flow to the extreme. Software packages/tools are meant to be applied and tested that lead to effective learning to imply businesses positively.

I can’t figure out how to view 2 screens side by side. When I try to “snap” one screen – the other screen disappears.

Replies (4) 

Which Microsoft Office product are you talking about. Let me take an example of Word and the same concept will be applicable for other MS Office products also.

Open both the documents > View Tab > Arrange All > Side by Side

Also let me know if you are talking about Dual Monitor here.

Best regards
Vijay A. Verma @ http://www.eforexcel.com/

Timezone: UTC+05:30, PST+12:30
Availability Hours (UTC) : 05:00 AM – 05:00 PM

1 person found this reply helpful

Was this reply helpful?

Sorry this didn’t help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Was this reply helpful?

Sorry this didn’t help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

First make sure you are not in Tablet Mode:
Press Windows key + A
On the Resulting Flyout, if you cannot see the Tablet Mode Button, click ‘Expand’
If the Tablet Mode Button is not gray, click it so it becomes gray
This will turn off tablet mode

Then once you are sure you are not in Tablet Mode:
Open Both Programs
Then right click your Taskbar (bottom of your Screen) and choose ‘Show Windows side by side’

Power to the Developer!

MSI GV72 – 17.3″, i7-8750H (Hex Core), 32GB DDR4, 4GB GeForce GTX 1050 Ti, 256GB NVMe M2, 2TB HDD

1 person found this reply helpful

Was this reply helpful?

Sorry this didn’t help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

Returns a zero-based, one-dimensional array containing a specified number of substrings.

Syntax

Split(expression, [ delimiter, [ limit, [ compare ]]])

The Split function syntax has these named arguments:

Part Description
expression Required. String expression containing substrings and delimiters. If expression is a zero-length string(“”), Split returns an empty array, that is, an array with no elements and no data.
delimiter Optional. String character used to identify substring limits. If omitted, the space character (” “) is assumed to be the delimiter. If delimiter is a zero-length string, a single-element array containing the entire expression string is returned.
limit Optional. Number of substrings to be returned; -1 indicates that all substrings are returned.
compare Optional. Numeric value indicating the kind of comparison to use when evaluating substrings. See Settings section for values.

Settings

The compare argument can have the following values:

Constant Value Description
vbUseCompareOption -1 Performs a comparison by using the setting of the Option Compare statement.
vbBinaryCompare 0 Performs a binary comparison.
vbTextCompare 1 Performs a textual comparison.
vbDatabaseCompare 2 Microsoft Access only. Performs a comparison based on information in your database.

Example

This example shows how to use the Split function.

See also

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.

VBA, just like any other language gives you a set of functions to perform various operations on strings. And VBA Split is one of those string functions. Microsoft introduced the Split function with VBA Version 6 (in Office 2000).

As the name suggests, the job of a Split statement is to break, split, or divide a string based on a particular criterion.

Split is one of the many Substring functions that can be used in VBA. I have written a whole post on these Substring functions, you can read it here.

How to use excel’s split screen function

Table of Contents

Definition and Syntax of VBA Split Function

Split can be defined as a function that can split a text string into an array, by making use of a delimiter character. It returns a zero-based, one-dimensional array holding the parts of the original text string.

The Syntax of VBA Split Statement is as follows:

Here, ‘ text_string ’ refers to the string that you need to break.

‘ delimiter ’ refers to the character which divides the string into parts. This is an optional argument, space character “ ” is treated as the default delimiter.

‘ limit ’ is an optional parameter. It specifies the maximum number of parts into which the input string should be divided. The default value is -1, which means that the string should be divided at each occurrence of ‘ delimiter ’.

‘ compare ’ is also an optional argument that specifies the comparison method to be used while evaluating the strings. ‘ compare ’ argument can have any one of the below values:

Constant Value Description
CompareMethod.Binary 0 Performs a binary comparison i.e. each character should only match itself.
CompareMethod.Text 1 Performs a textual comparison.

Some Important points about Split Function

  • Split Function returns a String Array and not a String.
  • If you omit the ‘compare’ argument then, Split Statement uses the Binary comparison method as default.
  • If the ‘text_string’ that you pass to Split is a zero-length string then, it returns a single-element array containing a zero-length string.
  • If the ‘delimiter’ is not found anywhere in the ‘text_string’, then Split returns the single-element array containing ‘text_string’ as it is.

How to Use VBA Split Function

Ok, now let’s see how you can use the Split function:

Objective: Let’s consider we have a string: “How are you” and now our objective is to break this string to separate out the words.

So, we will try to apply a Split Statement to it as:

‘ text_string ’: In this case, our ‘text_string’ would be “How are you”.

‘ delimiter ’: In this case, our delimiter would be space character (“ ”). But as I have foretold that, a space character is the default delimiter, so will leave this argument blank.

‘ limit ’: We will also leave the ‘limit’ argument blank because we need to separate out all the words from the given ‘text_string’.

‘ compare ’: This would be blank, as blank specifies binary comparison method.

So, the final Split Function would be:

Note: Now we need to receive the return from this split function, for this purpose we can use a string array.

So, the final code would be:

5 Examples using Split Function

Now let’s move on to some examples of Split Statements:

Example 1: Separate a list of pipe separated values i.e. A|B|C|D.

Below is the code to do this:

Example 2: Break the string (say: “Welcome to Excel Trick”) into separate words by using Split Function. And display the contents of the array returned by the Split using a message box.

Below is the code that can accomplish this task:

How to use excel’s split screen function

In this code, we have used a Split function to break the string into parts. Later, in the code, we have used a For loop to iterate the array returned by the Split Function in order to show the array contents using a message box.

Example 3: Use the above example, but hereafter splitting the string we just need to display its third part. To make it clearer, let’s say if I divide the string (“Welcome to Excel Trick”), then in this case I just need the output as “Excel” i.e. the third word in the string.

So, the code would be:

How to use excel’s split screen function

In this code, you would have noticed that instead of using a String Array for accepting the return from the Split Function I have taken a string variable. This is because by writing the Split Statement as: WrdString = Split(text_string)(2) , we are telling it to return only the third element of the array (which is a string) and not the complete array.

Example 4: Now use the same code of Example 2 just change it to demonstrate the use of limit argument.

How to use excel’s split screen function

The above code is very similar to the one that we have seen in Example 2. The only difference here is that we have supplied the limit argument to the Split function.

Notice: Because of the limit argument, the Split function divides the text string into 3 parts instead of 4.

Example 5: Write a code using the Split function that can count the number of words in a string.

Below is the code that can do this:

How to use excel’s split screen function

In this example, we have used the UBound function to get the upper bound of WrdArray() . The statement UBound(WrdArray()) gives the length of WrdArray() . But as we all know, that an array starts from index 0, so we need to add 1 to its upper bound to get the actual word count.

Example 6: Write a code that can import a CSV to a spreadsheet.

This code requires you to understand the basics of the FileSystemObject. So, before moving ahead I would recommend you read this post .

How to use excel’s split screen function

Below is the code to do this:

How to use excel’s split screen function
Explanation:

As we know that CSV files are comma-separated files. In this example, we are reading each line from a pre-existing CSV file and then by using the split function we are separating individual values from each line and writing them to the Active Sheet.

So, this was all about VBA Split Function from my side. Feel free to drop in your comments related to the topic.

You May Also Like

Well, I am Ankit Kaul, the founder of Excel Trick. I am a die-hard fan of Microsoft Excel and have been working with spreadsheets for the past 10+ years. My only aim is to turn you guys into ‘Excel Geeks’. Check out more about me here.

Excel is the perfect software for handling massive amounts of data. Sometimes, you will have to crunch through thousands of tables with countless categories and dizzying amounts of data. Things can get even more complicated when you have to compare elements in multiple sheets, which is where the split-screen feature jumps in.

How to use excel’s split screen function

It makes it possible to keep track of multiple files on the same screen, helping you get more work done faster. The feature is easy to set up, and once you figure it out, you will get a huge efficiency boost.

Setting Things up

There are two ways you can use the split-screen feature in Excel. The first one will allow you to see multiple areas of the same file, while the other one will enable you to see different files on your screen at the same time. You can also choose if you want to split the screen horizontally, vertically, or both. Here is what you have to do:

  1. Open Excel and click on the “View” tab.
  2. Select the “Split” icon and divide the screen to split it into four different panes.
    How to use excel’s split screen function

The feature includes both vertical and horizontal splitting, and each pane will show you the same worksheet. That makes it easier to monitor and compare different parts of the sheet at the same time.

You can move each bar horizontally and vertically until you find the parts you need. You can also reposition each pane by clicking and dragging it to a different position. However, having four separate panes can sometimes be a little confusing. However, you can reduce the number of panes to two.

Splitting the Screen into Two Panes

If you need only two panes, you can choose between vertical and horizontal split. Let’s say that you need only two horizontal panes. After splitting the screen into four panes, click on the vertical dividing line and drag all the way to the right. It will then disappear, and you will only have the horizontal split. The method works 2013, 2016, and 2019 versions of the software. If you are using Excel 2010, the setup is a little different.

How to use excel’s split screen function

Splitting the Screen into Two in Excel 2010

Excel 2010 doesn’t have a split-screen feature. It uses the split box instead. It can split the screen only vertically, which is what most people are looking for. Unlike the newer versions, Excel 2010 doesn’t have the split option under the “View” tab, but it’s still easy to set up. Here is what you have to do:

  1. Place the pointer just above the vertical scroll bar. The pointer will then change into a black arrow with two points.
  2. Hold down the left mouse button, and you will see a dark line appear above the first row in the file.
  3. Drag the pointer up or down, and the line will follow.
  4. Place the line where you want to split the screen and release the mouse button.
  5. When you split the screen, Excel will copy all of the data into the newly formed pane.
  6. You can repeat the same process for horizontal splitting, and you can reposition the split at any given time.

The steps above don’t work only for single Excel files. You can use the split-screen feature to open two or more sheets in parallel.

Opening Multiple Workbooks

You can also open multiple workbooks in the same excel file. That allows you to quickly refer to other files without having to switch tabs all the time. Here is what you have to do:

  1. Open all Excel files you want to use.
  2. Under the “View” tab, click on the “Arrange” option.
    How to use excel’s split screen function
  3. Select the type of split you want. You will get to choose between tiled, horizontal, vertical, and cascade.
  4. Each of the files will be displayed in a separate Excel screen within the original file.
  5. You can then even split those screens separately to access multiple areas of each file. You can split every separate window however you want it. You can also remove splits by dragging the line away from the file.
    How to use excel’s split screen function

Removing Split Screens

When you’re done, you can remove the split-screen feature by clicking on the “Split” box in the “View” tab. Everything will return to normal, and all changes will be saved automatically.

Excel in Excel

Tricks like the split-screen feature will make your life much easier when working with large Excel workbooks. Excel has many options and shortcuts and mastering them will give you more control and improve your efficiency.

Why do you use the split-screen feature in Excel? Did it help you finish your work faster? Tell us how you use it in the comments section below.