Select the Row under the last one that you want to remain visible and the
select Window > Freeze Panes
If you want the first 4 line to also print on every page then select File >
Page Setup > Sheet > Rows to Repeat at top enter 1:4
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
"Hans F." wrote in message
> 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