Select which panes to freeze

If you are seeking a world-class educational experience within a vibrant, Christ-centered learning community, Cedarville is the place for you. Step up to the challenge of our arts, sciences, professional and graduate programs, and achieve more than you ever imagined.

Be challenged and transformed by professors who are experts in their fields and invest their lives at Cedarville to mentor and guide students like you. The following steps show you how to use freeze panes in Excel , , , or Keywords: freeze cells, cells in place, office , repeat column headings, repeat headings.

What is your opinion about the content? Suggest new content or let us know how we can improve this content optional :. If you desire a response, please provide your email address optional :. Dave Johnson. You can freeze a row in Excel so it's easier to compare data as you scroll through the spreadsheet.

You can choose to only freeze the first visible row in your Excel sheet, or freeze multiple rows. To freeze a row or unfreeze it later you just need to use the "Freeze Panes" menu. Visit Business Insider's homepage for more stories. Dave Johnson is a technology journalist who writes about consumer tech and how the industry is transforming the speculative world of science fiction into modern-day real life.

Dave grew up in New Jersey before entering the Air Force to operate satellites, teach space operations, and do space launch planning. He then spent eight years as a content lead on the Windows team at Microsoft. As a photographer, Dave has photographed wolves in their natural environment; he's also a scuba instructor and co-host of several podcasts. Insider Inc. Additional comments. Email optional. When you freeze panes, Microsoft Excel keeps specific rows or columns visible when you scroll in the worksheet.

For example, if the first row in your spreadsheet contains headers, you might freeze that row to make sure that the column headers remain visible as you scroll down in your spreadsheet. A solid line under row 1 indicates that the row is frozen to keep column headers in place when you scroll. Splitting panes is a variation on freezing panes, in that when you split panes, Excel creates either two or four separate worksheet areas that you can scroll within, while rows or columns in the non-scrolled area remain visible.

Note: You cannot freeze panes and split panes at the same time. You can enable only one of the two. You can freeze only rows at the top and columns on the left side of the worksheet. You cannot freeze rows and columns in the middle of the worksheet.