http://gamingtrend.com
October 20, 2014, 06:50:24 PM *
Welcome, Guest. Please login or register.

Login with username, password and session length
News:
 
   Home   Help Search Calendar Login Register  
Pages: [1]   Go Down
  Print  
Author Topic: Need some Excel help  (Read 1422 times)
0 Members and 1 Guest are viewing this topic.
whiteboyskim
Senior Staff Writer
Gaming Trend Senior Member

Offline Offline

Posts: 7848


Hard partier


View Profile
« on: October 20, 2004, 03:42:49 PM »

Hey gang, I've got a question for you on Excel. How do you set it so that some rows (for example, the top two horizontal rows) are not only locked in place, but that when you scroll down the spreadsheet, those two rows remain frozen in place so when you scroll down, all the rows disappear underneath rows 1 and 2? Thoughts? Comments? Need more info?

I'm also using Office XP if that helps.
Logged

Behold the glory of my new blog!
Filmmaking is vision plus faith plus balls, all 3 of which Hollywood knows little about.
Jeff
Special Project Group
Gaming Trend Senior Member

Offline Offline

Posts: 3278



View Profile
« Reply #1 on: October 20, 2004, 03:50:46 PM »

Not to be a smartypants or anything, but ...

open Excel help, and in the answer wizard, type in 'freeze row', and the first result there will explain how to freeze the panes. Not sure if you can do 2 rows or not though.
Logged
whiteboyskim
Senior Staff Writer
Gaming Trend Senior Member

Offline Offline

Posts: 7848


Hard partier


View Profile
« Reply #2 on: October 20, 2004, 04:15:57 PM »

Well you're not being a smart-ass, I was using the wrong word. I was using "lock pane" instead of "freeze pane" so that clears that up.
Logged

Behold the glory of my new blog!
Filmmaking is vision plus faith plus balls, all 3 of which Hollywood knows little about.
Pages: [1]   Go Up
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2013, Simple Machines
Valid XHTML 1.0! Valid CSS!
Page created in 0.089 seconds with 29 queries. (Pretty URLs adds 0.028s, 2q)