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 Russell H. Your Own Question
Russell H.
Russell H., Computer Support Specialist
Category: Software
Satisfied Customers: 11532
Experience:  Proud to have been getting computer technicalities into working order since 1988.
13568747
Type Your Software Question Here...
Russell H. is online now

Can I freeze more than one row at the top of a sheet in

Resolved Question:

Can I freeze more than one row at the top of a sheet in Excel 2016? It offers the option of the top row, but I would like to freeze 2 or 3 consecutive rows.
Submitted: 29 days ago.
Category: Software
Expert:  Russell H. replied 29 days ago.

Hi, thank you for contacting JustAnswer.com. My name is***** will do my best to provide the right answer to your question.
Try this:

- first, select the row right below the rows you want to freeze (e.g. row C should be selected, to freeze rows A and B.)

- then, go to the View tab, and select the Freeze Panes command

- and choose "Freeze Panes."

I think that might work for you - let me know in Reply To Expert, whether it does or not, please. (If it does not work, I will advise you further to a solution.)

Customer: replied 29 days ago.
that works fine - many thanks.
Expert:  Russell H. replied 29 days ago.

Glad to hear that my advice was on-target. Before you go, please rate my answer - a five-star rating best expresses appreciation of the work I have done. Thank you, ***** ***** a great day.

Russell H. and 3 other Software Specialists are ready to help you