Split Screen Editing in Excel & Word

Jul 11, 2012 | All, How To... | 0 comments

A little known but useful feature when using Microsoft Excel or Word is the ability to see edit one part of the document or spreadsheet and see another part on the same screen. This is known as Split Screen editing.

This feature is especially useful when working with spreadsheets. Often you need to keep the column headers and/or the first few columns fixed on the screen whilst you work on the rest of the spreadsheet. You can do this by spitting the screen vertically and horizontally as demonstrated in the example below.

The same feature, splitting the screen vertically only, works a similar way in MS Word.

Example – Split Screen Editing in Excel

Figure 1 shows an example of an excel spreadsheet.

To split the screen horizontally click on the small vertical bar at the bottom right of the spreadsheet window (Figure 2). Then drag it left to where you want the split to occur. You can now scroll each part of the spreadsheet separately. To remove the split simply click the vertical bar and move it back to its original position at the right hand side of the spreadsheet.

To split the screen vertically click on the horizontal bar at the top right of the spreadsheet (Figure 3).

Figure 4 shows the same sheet as Figure 1 with vertical and horizontal splits in place.

Excel spreadsheet

Figure 1


Split screen 1

Figure 2

Split screen editing

Figure 3


Split screen editing

Figure 4






Submit a Comment

Your email address will not be published.

Written by
Mike Brogan
Mike is a website developer specializiing in website design, online marketing, ecommerce design, and consutancy. He has developed website for clients for over 20 years.

Related Posts

How Do Websites Work?

How Do Websites Work?

Have you ever wondered how websites work? This is the first in a series of posts aimed at explaining what's involved in designing, building, and running a website. These posts are aimed at people who want to have a website developed. They want to understand the basics...

eCommerce Systems Explained

eCommerce Systems Explained

These days, an online shop is a must for any business involved in selling goods and services to customers.

White Label Website Services

White Label Website Services

This article explains what white label website services are and how, as a professional who deals directly with business clients, you can benefit from these services. The Problem Let’s assume that you are a business consultant. You troubleshoot businesses that have...

Website Design – Facts and Fiction

Website Design – Facts and Fiction

You've decided that you need a website for your business, or you've already got one that's looking decidedly long in the tooth. You  approach a web designer who tells you his company will design the coolest-looking site you could get. It will cost, or course, but it...

I hope you enjoy reading this blog post.

If you want me to design a website for you or help you with internet marketing, click here.

Can Customers Find Your Website?

Download Mike’s “30 Website & SEO Tips” for free.

Web Design Secrets Revealed

Take your website design skills to the next level to steal a march on your competition and make your website a success.