Row always in screen view

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

Guest

I have a long list of items and would like the top row to always be in screen
view. How do you do this?

Thanks
 
Thank you for the reply, but that didn't work how I need it to. Then it
didn't allow me to scroll all the way back to the right when it I froze that
row.
Also, I want that row to always be at the top of the window when I scroll
down- freezing didn't do that.

Thanks
 
You did select A2, right?

The rule for freezing panes is.........everything above and left of the selected
cell will remain in view as you scroll down or across.


Gord Dibben MS Excel MVP
 

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

How do I keep rows a1-a2 always at top of screen when on row 50 1
Keep Headers at top of page 5
Any way to get Freeze Panes to work with Split View? 2
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
How do I stop the screen from jumping 2
Multiple Spits on one worksheet 2
Freeze top 2 rows - how 3
In Excel how do I show the contents of just 1 row as a form? 6

Back
Top