Freezing a cell range

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In my shared excel file, users will be adding information to the first free
row at the bottom of a list. I want to be able to freeze the top 5-6
"header" rows so that when users add new rows at the bottom, the "header"
stays at the top and won't get pushed out of sight. I don't believe this is
the same as protecting the cell range.

I can split the screen to keep it there, but was wondering if there is a
more elegant way of doing this.

tia,
 
If you want to freeze the top 6 rows on place, click into Cell A7 and choose
Window | Freeze Panes.

tj
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

can you split and freeze simultaneously in the same excel document 2
How do I freeze a row on the bottom of my screen? 4
How to fix an array or range 1
Hide or Freeze 3
Freeze Panes - Remove Line 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Can I freeze different rows? Can anyone help? 5
Any way to get Freeze Panes to work with Split View? 2

Back
Top