01-07-2004, 12:02 PM
|
#1 |
|
Admiral
  
Join Date: Mar 2001
Location: Utah
Posts: 5,420
|
Anyone here good with Excel?
Simple Excel question:
My Row 1 has all the headers I need for the whole file, and it scrolls down quite a ways, hiding the first row when I scroll down far enough. How do you "sticky" it to the top, even when you scroll far far down, it'll just be at the top of the sheet? TIA! 
__________________
And closer... |
|
|
|
01-07-2004, 12:04 PM
|
#2 |
|
captain awesome
Join Date: Jan 2003
Posts: 7,054
|
Place the cursor where you want to freeze the "panes" and then go to:
Window >> Freeze Panes |
|
|
|
|
01-07-2004, 12:32 PM
|
#3 |
|
Admiral
Join Date: Mar 2001
Location: Utah
Posts: 5,420
|
Sweet! Only problem is that I have half of my screen filled in, and it's keeping the whole half frozen and scrolling the bottom half. I need it to scroll everything but the top. I selected all of Row 1 to freeze, but maybe I should have selected one cell or something else just to get the first row to stay?
|
|
|
|
|
01-07-2004, 12:40 PM
|
#4 |
|
Arrrhh!
Join Date: May 2000
Location: LI NY
Posts: 6,807
   |
Rather than Freeze, use Window > Split and then drag the top window pane to an appropriate size.
__________________
A priest, a paladin and Varimathras walk into a bar... |
|
|
|
|
01-07-2004, 12:41 PM
|
#5 | |
|
Captain
 
Join Date: Jan 2003
Location: Aurora, OH
Posts: 1,967
|
Quote:
Select the row below row 1 and do freeze panes.
__________________
Peter: Lois, you've got a sick mind! Lois: Peter, I'm talking about making love. Peter: Oh, I thought you wanted us to murder the children and harvest their organs for beer money. |
|
|
|
|
|
01-07-2004, 12:52 PM
|
#6 | |
|
Admiral
Join Date: Mar 2001
Location: Utah
Posts: 5,420
|
Quote:
|
|
|
|
|
Linear Mode
