Split Screen in Excel 2010

When dealing with large amounts of data in an Excel worksheet, you often need to use the Split Screen item on the ribbon or menu. This option divides your screen into 4 sections and allows you to scroll through these sections while keeping other sections of your worksheet visible.

For example if you have a worksheet with column titles across the top and several different sections of data throughout the worksheet, as you scroll to the various different areas of the worksheet you would not be able to see the different sections unless you split the screen. Think of it as having 2 or more views of your worksheet - almost like a picture in picture on your television.

Split Screen into Sections

You would do this by simply going to the View tab and selecting View/Split as shown below (click to enlarge):

522cfd4a84349 

View of Screen Split

Below is a screen shot of the worksheet split into sections after preforming the above action (click to enlarge):

522cfd4ae7822

Moving the split to see the areas of your worksheet

You can drag the dividers to better aline them with your data as shown below. (click to enlarge):

522cfefb8efd8

Scroll in each of the four windows

You can also scroll within each view/window to better align your data. (click to enlarge):

522d001a96517

Remove One of the Dividers

You can remove one of the dividers if you only want your worksheet divided into two areas. Drag the bar you want to remove to the edge of the sheet, i.e., to remove the horizontal bar, drag it to the top - to remove the vertical bar, drag it to the left and they will disappear. (click to enlarge):

522d0210c2457

Remove Split View

To remove the split view entirely, simply go to View and click the Split button. (click to enlarge):

 522cfd4a84349

If you need assistance on any other Microsoft Office ribbon/menu item in Excel please feel free to Contact Us - and don't forget to "Like" us on Facebook! Thanks and I hope this has been helpful. Arlene

Arlene Dickerson

Co-Owner / Director

Technical Resource Solutions, LLC

This email address is being protected from spambots. You need JavaScript enabled to view it.

{flike}

What to Look for in a Training Class or Seminar
Getting Organized in 2013 with Microsoft OneNote

Related Posts

 

Comments

No comments made yet. Be the first to submit a comment
Already Registered? Login Here
Guest
Monday, 16 September 2019
If you'd like to register, please fill in the username, password and name fields.