Click to See Complete Forum and Search --> : Anyone good with Excel?
Ryan8720
12-04-2004, 08:24 PM
Is there a way to make row of a worksheet stationary so that it doesn't scroll with the rest of the page? Such as the heading of a table. I thought I'd seen it done before, but I cant figure out how.
http://www.edgewebdesign.org/images/misc/ryan_shadowmetal.gif (http://www.edgewebdesign.org)
http://www.spreadfirefox.com/community/images/affiliates/Buttons/80x15/white_1.gif (http://www.spreadfirefox.com/?q=affiliates&id=30444&t=82')
Ryan, I have a pretty old version of Excel but it should still be the same.
First go to Window/split
Then if you don't need the vertical split just drag it to the left into the row numbers to get rid of it.
Then set the horizontal window divider thingy at the bottom of the part you don't want to scroll.
Then go to Window/freeze panes.
This should do it. /emoticons/cool.gif
I love children but I don't think I could eat a whole one.
PrintDriver
12-05-2004, 01:05 AM
Which version, cuz I just choose the entire row below the one I want to freeze the go to Window/freeze panes.
PrintDriver is a grande format digital print dude. His advice/opinions may not apply to the 4color/offset/web world of printing
Ryan8720
12-05-2004, 04:18 AM
Yeah, I have Excel 97, so that worked perfectly thanks.
http://www.edgewebdesign.org/images/misc/ryan_shadowmetal.gif (http://www.edgewebdesign.org)
http://www.spreadfirefox.com/community/images/affiliates/Buttons/80x15/white_1.gif (http://www.spreadfirefox.com/?q=affiliates&id=30444&t=82')
LOL, I have 95. I just never found any reason to upgrade. PD's method works in mine too. Not sure why I've always done it the hard way LOL. I didn't like the way 97 put the VBA mods in a different place. Plus they added a bunch of other crap I never used. I like having the mods as a tab right there at the bottom so I don't have to hunt around for them. /emoticons/biggrin.gif
I love children but I don't think I could eat a whole one.