Freeze the first line of a sheet

Mike van der Merwe · External Since: May 31, 2011 Posts: 2

Hi !
In Windows Excel 2003 it was easy to freeze the first line of a sheet
so that when scrolling down it stays in line 1

How is this done in Windows Excel 2007

Some help please

Mike

trip_to_tokyo · External Since: Oct 03, 2009 Posts: 94

On May 31, 2:11 pm, "Mike van der Merwe"
wrote:
> Hi !
> In Windows Excel 2003 it was easy to freeze the first line of a sheet
> so that when scrolling down it stays in line 1
>
> How is this done in Windows Excel 2007
>
> Some help please
>
> Mike

Click in cell B2.

View tab.

Window group.

Click on:-
Freeze Panes

- then click on:-

Freeze Panes

- again.

Stan Brown · External Since: Mar 24, 2005 Posts: 525

On Tue, 31 May 2011 15:11:12 +0200, Mike van der Merwe wrote:
>
> Hi !
> In Windows Excel 2003 it was easy to freeze the first line of a sheet
> so that when scrolling down it stays in line 1
>
> How is this done in Windows Excel 2007
>
> Some help please
>
> Mike

Please don't post the same query multiple times.

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com
Shikata ga nai...

Mike van der Merwe · External Since: May 31, 2011 Posts: 2

Sorry for the cross posting
Thanks Again

"Stan Brown" wrote in message

> On Tue, 31 May 2011 15:11:12 +0200, Mike van der Merwe wrote:
>>
>> Hi !
>> In Windows Excel 2003 it was easy to freeze the first line of a sheet
>> so that when scrolling down it stays in line 1
>>
>> How is this done in Windows Excel 2007
>>
>> Some help please
>>
>> Mike
>
> Please don't post the same query multiple times.
>
> --
> Stan Brown, Oak Road Systems, Tompkins County, New York, USA
> http://OakRoadSystems.com
> Shikata ga nai...