How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Erik B. Your Own Question

Erik B.
Erik B., Consultant
Category: Microsoft Office
Satisfied Customers: 4614
Experience:  Well versed in several editions of Microsoft Office.
Type Your Microsoft Office Question Here...
Erik B. is online now
A new question is answered every 9 seconds

In Excel 2010, with a vertically tall document, I want to

This answer was rated:

In Excel 2010, with a vertically 'tall' document, I want to 'freeze' the column headings created in the first few lines.

In other words, when I am 50 lines down the document, I want to be able to see the column headings.

I hope that makes sense.
Makes perfect sense! This is called 'Freezing Panes' in Excel 2010. MS has created a short tutorial video here:

But the basic operation is:

  1. Highlight the row below the column headings.
  2. Click the View tab in the Ribbon.
  3. Click on Freeze Panes.
  4. Click on Freeze Top Row.



That's it. Now no matter how far you scroll down the column headings will be visible. Thank you again!

Customer: replied 3 years ago.

Many thanks, XXXXX XXXXX excellent service!

Absolutely Richard, thank you again!
Erik B. and 2 other Microsoft Office Specialists are ready to help you