Excel/Freeze Panes

Advertisement


Question
I hope you can help me with this basic question.  I am wanting to freeze the panes on my excel sheet, but I can not remember where to find the link to do this.  I am only wanting to freeze the first row.

Thanks,

Ray

Answer
Hello Ray,  Thank you for your question and the opportunity to assist you.

I am going to assume you are using Excel 2007 or 2010.  If not, in a follow-up question let me know which version you are using and I will provide a more specific answer applicable to the version you are using.

In Excel 2007 or 2010, click on "View" and on the right side of the ribbon you will see "Freeze Panes."  Click on "Freeze Panes" and three options appear.  If you only want the first row frozen, click on the middle option, "Freeze Top Row."

Hopefully this helped you solve your problem.  If not, or if you need additional help on this issue, let me know.

Thanks,

David
About Excel
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here

Excel

All Answers


Answers by Expert:


Ask Experts

Volunteer


David W. Cofer

Expertise

I can answer MS Excel questions regarding Excel Formulas, Functions, Worksheets, Data Validation, Conditional Formating, Lookup, Pivot Tables and Logic Functions, as well as other general Excel questions. I do not answer questions regarding Charts, Macros, Visual Basic or Programming. Please include the version of Excel you are using. That helps me provide an answer that will work on your system. Also, do not submit duplicate questions to several experts at the same time. If several of us are answering the same question at the same time, it is a waste of time and resources. If the first expert you ask does not provide an acceptable answer, then ask a second expert. As we are volunteers, our time is valuable, and it is a waste of time for 5 of us to be working on the same question at the same time. Thanks for your understanding.

Experience

I have used MS Excel for over 20 years and am familiar with all versions back to 1993. I currently use Excel 2013 and assist those using versions going back to 2000. I use Excel extensively at both work and home.

Education/Credentials
I hold a B.A. degree in Psychology.

©2016 About.com. All rights reserved.