Can Excel show the column headers on every screen? How to freeze panes and split screens

How to freeze and unfreeze columns and rows in Excel.

Credit: Rob Schultz

Can Excel show column headers on every screen? Yes, in Excel it’s called Freezing Panes, which can be applied to columns or rows (or both), and it’s super-simple. We’ll also show you how to split screens, a similar feature. Both options make it easier to navigate big spreadsheets without losing track of basic data.

Freeze and Unfreeze Panes in Excel

The Freeze feature in Excel allows you to scroll down through hundreds of rows and still see the original headers or field names in row 1, or scroll over hundreds of columns and still see the data such as a product or person’s name in column A. 

1. Open your spreadsheet and select View > Window (group) > Freeze Panes > Freeze First Column, and it’s done. Now you can see the company or product names beyond the first screen; that is, column A remains stationary at left while you move your cursor to the right as far as needed (even to the very last column XFD).

2. To freeze the headers across the top on row 1, select View > Window (group) > Freeze Panes > Freeze Top Row, and it’s done. Now you can scroll down through hundreds of rows and the headers remain stagnant at the top of each screen.

3. If, however, your headers are stacked in multiple cells (on multiple rows, for example), or you have a title on your spreadsheet, you’ll want to freeze more than just the top row.

4. In this case, position your cursor in a cell just below the header(s) you want to freeze. For example, to freeze both rows 1 and 2, position your cursor in Row 3 and select View > Window (group) > Freeze Panes. Excel freezes both row 1 and row 2. Press the Page Down key, and notice that the cursor moves down through the spreadsheet and the headers remain stationary at the top.

01 freeze the rows columns of cells on your spreadsheet JD Sartain / IDG Worldwide

Freeze the rows and columns of cells on your spreadsheet

5. The same applies to columns. For example, if you move your cursor to column C and select View > Window (group) > Freeze Panes, Excel freezes both columns A and B.

6. To disable the frozen panes, just select View > Window (group) > Freeze Panes > Unfreeze Panes and the spreadsheet returns to its original state.

You can also split the spreadsheet into quadrants, which makes it easier to work on columns or rows that are full screens apart. For example, if you split the spreadsheet in two vertical sections, you can copy and paste cells from column B (in the left section) to column AD (in the right section), without having to cursor over 28 columns or move several pages to the right.

1. With Window Split, you must position your cursor to the right of the column where you want the split to break, or just below the row you want the split to break. Just select View > Window (group) > Split, and the window divides into halves or quadrants at the location where your cursor resides.

02 the window splits at the top left or in the middle of the spreadsheet JD Sartain / IDG Worldwide

02 The window Splits at the top, left or in the middle of the spreadsheet

2. If the window fails to split where you need it, you can easily move the dividers. Just position your cursor on top of the intersecting vertical and horizontal lines. When the cursor changes into a cross with arrows on the ends, hold down the left mouse button and drag the split to its new location.

03 move the horizontal and vertical lines of the split window where ever you need it JD Sartain / IDG Worldwide

Move the horizontal and vertical lines of the split window where ever you need it

3. To remove the Split, just select View > Window (group) > Split again, and the split window disappears revealing the full spreadsheet again.

For more samples and detailed instructions regarding Freeze/Unfreeze and Split windows in Excel, check out our Excel tips for huge spreadsheets.  

Join the newsletter!

Or

Sign up to gain exclusive access to email subscriptions, event invitations, competitions, giveaways, and much more.

Membership is free, and your security and privacy remain protected. View our privacy policy before signing up.

Error: Please check your email address.

Tags Office 2013Office 2016

Keep up with the latest tech news, reviews and previews by subscribing to the Good Gear Guide newsletter.

JD Sartain

PC World (US online)
Show Comments

Essentials

Mobile

Exec

Budget

TerraCycle Zero Waste Box Pens and Markers Small

Learn more >

Back To Business Guide

Click for more ›

Most Popular Reviews

Latest Articles

Resources

PCW Evaluation Team

Christopher Low

Brother RJ-4230B

This small mobile printer is exactly what I need for invoicing and other jobs such as sending fellow tradesman details or step-by-step instructions that I can easily print off from my phone or the Web.

Aysha Strobbe

Microsoft Office 365/HP Spectre x360

Microsoft Office continues to make a student’s life that little bit easier by offering reliable, easy to use, time-saving functionality, while continuing to develop new features that further enhance what is already a formidable collection of applications

Michael Hargreaves

Microsoft Office 365/Dell XPS 15 2-in-1

I’d recommend a Dell XPS 15 2-in-1 and the new Windows 10 to anyone who needs to get serious work done (before you kick back on your couch with your favourite Netflix show.)

Maryellen Rose George

Brother PT-P750W

It’s useful for office tasks as well as pragmatic labelling of equipment and storage – just don’t get too excited and label everything in sight!

Cathy Giles

Brother MFC-L8900CDW

The Brother MFC-L8900CDW is an absolute stand out. I struggle to fault it.

Luke Hill

MSI GT75 TITAN

I need power and lots of it. As a Front End Web developer anything less just won’t cut it which is why the MSI GT75 is an outstanding laptop for me. It’s a sleek and futuristic looking, high quality, beast that has a touch of sci-fi flare about it.

Featured Content

Product Launch Showcase

Don’t have an account? Sign up here

Don't have an account? Sign up now

Forgot password?