How do I fix (prevent scrolling) of part of an Excel worksheet?

  • Thread starter Thread starter katherin
  • Start date Start date
K

katherin

How do I fix the first few rows of a .xls file so that they remain visible
when I scroll the worksheet down?
 
Suppose you want the top 4 rows to remain on screen as you scroll
down. Position the cursor in cell A5 then click on Window | Freeze
Panes.

If you also want the first column to be visible if you scroll to the
side, put your cursor in B5 and then Window | Freeze Panes.

Hope this helps.

Pete
 
Hi,
Use Freeze Pannels, Position yourself one row down the data you want to be
visible and then go to the menu, Window, Freeze pannels
 
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

Worksheet(s) open to last used row 5
Repeat rows on top - in worksheet - not printing! 2
how do I fix the position of a worksheet in excel? 1
Is there a way to restrict the view of a worksheet 1
excel opening view help needed 0
How the data may stay on top with scroll ? 1
Excel How to Fix Damaged Excel File That Won't Open? 3
Excel Columns moving up and down on their own in a worksheet. What Goes? 2

Back
Top