Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
biglou
 
Posts: n/a
Default 2 row that wont scroll down


How can i make a spreadsheet with the 2 first row that will stay in
place (on top of the sheet) when scrolling down the spreadsheet



TKS

Biglou;)


--
biglou
------------------------------------------------------------------------
biglou's Profile: http://www.excelforum.com/member.php...o&userid=32762
View this thread: http://www.excelforum.com/showthread...hreadid=525940

  #2   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme
 
Posts: n/a
Default 2 row that wont scroll down

Click on the 3 in the row headers
Use menu command Window | Freeze Pane

You can later use Windows | Unfreeze
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"biglou" wrote in
message ...

How can i make a spreadsheet with the 2 first row that will stay in
place (on top of the sheet) when scrolling down the spreadsheet



TKS

Biglou;)


--
biglou
------------------------------------------------------------------------
biglou's Profile:
http://www.excelforum.com/member.php...o&userid=32762
View this thread: http://www.excelforum.com/showthread...hreadid=525940



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
Scroll horizontaly with mouse, create same system used to scroll . frederic New Users to Excel 5 October 9th 05 08:15 PM
Scroll the screen view with the scroll bar avbs Excel Discussion (Misc queries) 1 June 25th 05 04:43 PM
Mouse scroll jumps from up/down to left/right Chris Excel Discussion (Misc queries) 0 April 15th 05 05:48 AM
vertical scroll bar goes too far? ScottSabo Excel Discussion (Misc queries) 2 April 6th 05 08:53 PM
scroll bar Yevgeny Azrieli Excel Discussion (Misc queries) 1 December 16th 04 05:39 PM


All times are GMT +1. The time now is 12:42 AM.

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

About Us

"It's about Microsoft Excel"