Course Content

Course Content

Splitting Sheets in MS Excel

How to Split Sheets in MS Excel

Now you will see an interesting feature of MS Excel that is 'Split sheets'.

Now sometimes we want to compare two data with each other but they exist far apart for example one data which we want to compare is at 6th row and another one is at 23rd row, so in that case we will use 'split' button from our VIEW tab.

When we use it we can see that our screen will be divided into two parts, and we will be provided with two different scroll bar for each one.

Now if we do not want to use that feature anymore then we can again click on that 'split' option to cancel it.

We can do this similar activity with column which will provide us two different scroll bars at horizontal.

Additionally we can use this 'split' feature for both row and column together at one time which will give us two scroll bars at horizontal bottom and two scroll bars at vertical right.


Spilting Sheets is a spreadsheet tool designed to help users easily split a large spreadsheet into smaller ones. As you enter data into the spreadsheet, the program automatically divides it into two or more side-by-side sheets, depending on the formula that it finds. This allows for complex calculations and decisions to be made based on a simple formula.Spilting Sheets is the tool for you. It's an easy way to split large sheets into multiple smaller ones. You can also take advantage of the multiple split panes to work with different parts of your spreadsheet at the same time. To split a pane, select the row or column you want the split to occur at, then on the View tab in the Window group, click Split. To remove a split pane, click Split again

In case you are wondering how to split sheets in MS Excel 2016, you should know that there are a lot of ways to do it. 1. Split by column headings: Go to the “Home” tab and click on “Split Cells” in the bottom right corner of the ribbon. Then select “Column Headings” from the drop-down menu. 2. Split by numbers: In this tactic, you will select a range that has numbers in it that add up to your desired number of columns or rows. Then click on "Split Cells" from the bottom right corner again and choose "By Number". 3. Split by values: In this method, you will enter a value for each cell in your spreadsheet and then select "Split Cells" from.

Microsoft Excel 2016 introduced the Worksheet Window, which allows you to split your workbook into two different worksheets. This can be useful when you want to share a wide range of data with another person and still be able to focus on your own work. Some people might find it difficult to split the window into two sections at first, but there are a few ways that you can do it easily. 1. Drag a border onto the new section that is going to be created, then position it at the bottom of the window. 2. Create a new sheet by holding down Shift and clicking on New Sheet on the ribbon bar on top of your screen. 3. Create a new section by holding down Ctrl and clicking on New Section from the ribbon bar on top of your screen.

Recommended Courses

Share With Friend

Have a friend to whom you would want to share this course?

Download LearnVern App

App Preview Image
App QR Code Image
Code Scan or Download the app
Google Play Store
297K+ Downloads
App Download Section Circle 1
4.5 Rating
App Download Section Circle 2
10K+ Reviews
App Download Section Circle 3
  • Learn anywhere on the go
  • Get regular updates about your enrolled or new courses
  • Share content with your friends
  • Evaluate your progress through practice tests
  • No internet connection needed
  • Enroll for the webinar and join at the time of the webinar from anywhere