Thread: How do I fix (prevent scrolling) of part of an Excel worksheet?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
  
Posts: 8,856
Default How do I fix (prevent scrolling) of part of an Excel worksheet?
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

On Jan 5, 3:49*pm, katherin
wrote:
How do I fix the first few rows of a .xls file so that they remain visible
when I scroll the worksheet down?

Reply With QuoteReply With Quote