Follow Us

Your Personal and Professional Development: Plans, Tips and Lists

Powered by Bookboon, your personal eLibrary with 1,700+ eBooks on soft skills and personal development

Excel 2016: How to Split Cells in Excel for a Better View

Posted in Articles
What are the different ways of viewing Excel 2016’s worksheets?

How to make your work easier when splitting large worksheets

Working on a huge workbook that has significant information all throughout its part is very tedious and time-consuming; especially when you are constantly scrolling up, down, left and right just to see and work at different parts.

Well, worry no more! By using the different views of Excel 2016, you will be able to save lots of time and effort in manipulating your workbooks and worksheets.
Imagine you have two copies of a worksheet and you are able to control both of them independently or two different worksheets of a single workbook both seen on your screen. Then, whatever you do on the first copy will be automatically applied to the other one. Isn’t that great? How is that possible? Simply because you’re really working on ONE worksheet which only appears double on your screen at the same time. Now, that’s incredibly amazing!

Splitting the Window

In using this option, the worksheet will split above and to the left of where your cursor is.

Click on the picture to extend it.

  1. Click on the worksheet where you want to split the worksheet.
  2. Click on the View tab.
  3. Click the Split button.
  4. You can now scroll in the top or the bottom half, just like below:

Click on the picture to extend it.

How to remove the split?

  1. Click on the View tab.
  2. Click on Split. (as shown below)


Opening Two Copies of the Same Workbook

When working with Excel, there are times that you need to view two worksheets of the same workbook at the same time. For instance, you have a summary worksheet and you need to see the effect of making a change on one of the spreadsheets that feed into it. To make things easier, you can open a second copy of the workbook in a new window and then arrange the windows side by side so that you can see both of them. Whenever you make a change on the first worksheet, you will be able to see the effect on the other one. Indeed, a very powerful feature! How to do it? Follow the steps below:

  1. Go to the View Ribbon.
  2. Click on New Window.
  3. A new window will appear.

Click on the picture to extend it.

  1. Go to the View Ribbon
  2. Click on Arrange All and a dialog box will appear.

Click on the picture to extend it.

  1. Select the way you wish to see the worksheets arranged.
  2. Tick Windows of active workbook.
  3. Click OK.

In this example, vertical is selected. Now, there are two copies that are arranged side by side.

Click on the picture to extend it.

With this view, you will be able to work quickly and easily since both of the worksheets that you need are on sight.

Try it and enjoy working!

We have even more useful articles:

Excel 2016 Core Part One

Get more of these and other tricks for Excel 2016 by downloading and reading our eBook Excel 2016 Core Part One. 

Read now