Excel sheet: scroll down, but leave first lines visible

[Hans F.]

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

 

[Sandy Mann]

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

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Elkar]

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.]

Hi Sandy

Thanks for your answer, but since i work on a german version i could not
find some

window that relates to the Window Freeze Panes...

However: I found the print part and it works.

You have a clue how to get me to the right window ??

hans

 

[Sandy Mann]

Hi Hans,

The *Window* that I was talking about was the drop-down Window menu on the
Menu bar at the top of the screen. Mine starts off File, Edit, View, etc.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk