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 Bryan Your Own Question
Bryan, Computer Support Specialist
Category: Computer
Satisfied Customers: 13092
Experience:  8+ years of professional support for tech-related issues, including computers, email and software.
Type Your Computer Question Here...
Bryan is online now

In an excel spreadsheet how do you freeze the top row(s) so

Customer Question

In an excel spreadsheet how do you freeze the top row(s) so the the column headings remain on the screen when you scroll down the pages. My text book says click Freeze Panes (Window Menu) But where is that on the screen?
I have windows 7 plus
John Jenner
Submitted: 2 years ago.
Category: Computer
Expert:  Bryan replied 2 years ago.
Hi, and thank you for asking your question. What's the version of Excel, e.g. 2007, 2010, 2013, you are using? Please reply back to me below. Thank you.
Expert:  Bryan replied 2 years ago.
Please do this in Excel now: Open up the spreadsheet, and then click on the top row heading (labelled 1) at the top-left, to select the top row. Next, click on the View tab at the top of the window, and in the Window group, click the arrow below Freeze Panes. Finally, click Freeze Top Row. This should do it. If you need more help, please use the Reply box to continue our conversation. Otherwise, I'd appreciate it if you could kindly take a moment to RATE my service by clicking on (and submit) a star rating at the top of this page. Thank you!
Customer: replied 2 years ago.
I am using windows 2010
But where is this "view" tab at the top of windows. No view tab so no access to freeze
Expert:  Bryan replied 2 years ago.
I see, no issues. Please leave me a reply when you are available next, and I'll set up a quick remote session and assist you with this issue accordingly. Thank you.