Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default How to make the scrolling not include the top rows of the sheet

I have seen in other excel document people managed that the top rows is not
included when scrolling instead they stay at the top. How do I do this.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,942
Default How to make the scrolling not include the top rows of the sheet

hi
on the menu bar....
Windowfreeze panes.
you can freeze rows and/or columns

Regards
FSt1

"Magrano" wrote:

I have seen in other excel document people managed that the top rows is not
included when scrolling instead they stay at the top. How do I do this.

  #3   Report Post  
Posted to microsoft.public.excel.misc
ed ed is offline
external usenet poster
 
Posts: 82
Default How to make the scrolling not include the top rows of the sheet

On Aug 2, 2:06 am, FSt1 wrote:
hi
on the menu bar....
Windowfreeze panes.
you can freeze rows and/or columns

Regards
FSt1



"Magrano" wrote:
I have seen in other excel document people managed that the top rows is not
included when scrolling instead they stay at the top. How do I do this.- Hide quoted text -


- Show quoted text -


Or, Just split the screen from that same Windows Menu. If split you
can move the divider around. In either case you can do just columns,
just rows, or both.

ed

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 663
Default How to make the scrolling not include the top rows of the sheet

Hi,

To freeze the window pane, just click the second rows below the header and
click Freeze panes from the Window menu.

Challa Prabhu

"Magrano" wrote:

I have seen in other excel document people managed that the top rows is not
included when scrolling instead they stay at the top. How do I do this.

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
Extracting Rows to Make A Totals Sheet Savage Excel Worksheet Functions 5 July 26th 07 12:36 AM
Extracting rows from worksheets to make a totals sheet Savage Excel Discussion (Misc queries) 0 July 24th 07 05:56 PM
Excel 2003 -Rows hidden. Scrolling unhides rows ! How do I stop th Excellent1975 Excel Discussion (Misc queries) 0 June 21st 06 08:01 PM
Can you make all sheets scroll when scrolling one sheet billy boy Excel Worksheet Functions 1 November 23rd 05 06:56 PM
make a macro to move specific rows to another sheet braxton Excel Worksheet Functions 1 February 21st 05 09:01 PM


All times are GMT +1. The time now is 06:22 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"