Tech Talk Discuss PC Hardware, Software, Internet and Other Technology

Excel Question

Old 08-29-02, 04:22 PM
  #1  
DVD Talk Hall of Fame
Thread Starter
 
Blake's Avatar
 
Join Date: Feb 1999
Location: Orange
Posts: 7,736
Excel Question

I've seen Excel sheets that have a row up top that, even if you scroll down, it stays at the top of the sheet. How do I do that?

Thanks in Advance.
Blake is offline  
Old 08-29-02, 04:27 PM
  #2  
Moderator
 
Groucho's Avatar
 
Join Date: Mar 2000
Location: Salt Lake City, Utah
Posts: 70,641
1 To freeze the top horizontal pane, select the row below where you want the split to appear.

To freeze the left vertical pane, select the column to the right of where you want the split to appear.
To freeze both the upper and left panes, click the cell below and to the right of where you want the split to appear.

2 On the Window menu, click Freeze Panes.
Groucho is offline  
Old 08-29-02, 04:45 PM
  #3  
DVD Talk Hall of Fame
Thread Starter
 
Blake's Avatar
 
Join Date: Feb 1999
Location: Orange
Posts: 7,736
So simple - yet, why the heck would they put that in the Window menu??

Thanks!
Blake is offline  
Old 08-29-02, 07:21 PM
  #4  
DVD Talk Limited Edition
 
Nefarious's Avatar
 
Join Date: Apr 2001
Location: In the Middle
Posts: 5,026
You can quickly do this with your mouse too. If you look at the side scroll bar just above the arrow that you would click to scroll up a worksheet. There's a an extra separation there and if you hang your mouse cursor there it will turn to up and down arrows with a thin black line. Click and hold and drag down until the rows you want to stay locked at top are in the top half. Then you can scroll down in the lower portion and the top window stays locked.

As for why it's in the Window menu...who knows. I find it more confusing that Header and Footer are found under the View menu in Word.
Nefarious is offline  

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Thread Tools
Search this Thread

Archive Advertising Cookie Policy Privacy Statement Terms of Service

Copyright 2018 MH Sub I, LLC dba Internet Brands. All rights reserved. Use of this site indicates your consent to the Terms of Use.