View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
Elkar Elkar is offline
external usenet poster
 
Posts: 964
Default Excel sheet: scroll down, but leave first lines visible

First, highlight Row 5
Then, from the Window Menu choose "Freeze Panes"

If you're using Excel 2007, then the "Freeze Panes" option is located in the
Window section of the VIEW tab.

HTH,
Elkar



"Hans F." wrote:

Hi all

Have to solve a problem fast:

Excel sheet has in the first 4 lines text that i want to have visible at all
times
( fix on top ) even when i scroll down on the sheet......

How can i do it.

Thanks for your help
either here in the NG or to: wette-2(at)ballonfahrer(dot)ch

Hans