Help!

Excel sheet: scroll down, but leave first lines visible

 
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> New Users RSS
Next:  How can I increase my price list by 5%, multiply ..  
Author Message
Hans F.
External


Since: Aug 09, 2007
Posts: 1



PostPosted: Fri Aug 10, 2007 1:23 am    Post subject: Excel sheet: scroll down, but leave first lines visible
Archived from groups: microsoft>public>excel>newusers (more info?)

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
Back to top
Sandy Mann
External


Since: Jun 14, 2005
Posts: 1292



PostPosted: Fri Aug 10, 2007 1:23 am    Post subject: Re: Excel sheet: scroll down, but leave first lines visible [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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

sandymann2@mailinator.com
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
>
> Hans
>
>
Back to top
Elkar
External


Since: Mar 07, 2006
Posts: 605



PostPosted: Fri Aug 10, 2007 1:23 am    Post subject: RE: Excel sheet: scroll down, but leave first lines visible [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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
>
>
>
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> New Users All times are: Eastern Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum