Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2
Default 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



  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 833
Default 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.
  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 524
Default 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...
  #4   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2
Default 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...




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I freeze rows in the middle of a worksheet? (Line 14-15) Smiley[_2_] Excel Worksheet Functions 4 December 30th 08 10:19 PM
Freeze Panes - Remove Line Mathew P Bennett Excel Discussion (Misc queries) 1 August 13th 08 08:09 PM
How do I freeze a line in an Excel graph when printing 3PL Bill Excel Discussion (Misc queries) 1 April 23rd 08 12:57 PM
Validation above the Freeze Line CLR Excel Discussion (Misc queries) 4 April 20th 05 12:55 PM
Freeze pane line Bob G Excel Discussion (Misc queries) 2 March 13th 05 06:53 PM


All times are GMT +1. The time now is 05:56 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"