ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Freeze the first line of a sheet (https://www.excelbanter.com/new-users-excel/270676-freeze-first-line-sheet.html)

Mike van der Merwe

Freeze the first line of a sheet
 
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[_3_]

Freeze the first line of a sheet
 
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

Freeze the first line of a sheet
 
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

Freeze the first line of a sheet
 
Sorry for the cross posting
Thanks Again

"Stan Brown" wrote in message
t...
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...






All times are GMT +1. The time now is 07:31 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com