Jump to content


Help With Microsoft Excel


  • You cannot reply to this topic
4 replies to this topic

#1 NickC

    Senior Class President 2010

  • BTHSnews Alumni
  • PipPipPipPipPipPipPipPipPipPipPip
  • 4873 posts
  • Gender:Male
  • Location:Buffalo, NY
  • Major:IAS
  • Class of: 2010
  • Status: Alum
  • College:University at Buffalo

Posted 20 March 2008 - 08:37 PM

Hey everyone,

I need some help with excel. There is this function that you can use to separate a title of a column but you can still scroll down to keep the title on top.

Like for example: http://www.bths.edu/ourpages/auto/2008/3/6...ta.xls?rn=32174

On that you can keep the title "AVG, SATs, etc.." and you can still scroll down to see the info. How can I get that dividing thingy out?

BTHS Student Government: Senior Class President 2010
International Arts and Sciences
University at Buffalo, the State University of New York '14
Medicinal Chemistry


#2 djharkavy

    Forum Addict

  • Donors
  • PipPipPipPipPip
  • 669 posts
  • Gender:Male
  • Location:Bayside, NY
  • Major:N/A
  • Status: Staff
  • College:University of Rochester

Posted 20 March 2008 - 08:53 PM

View PostNickC, on Mar 20 2008, 09:37 PM, said:

Hey everyone,

I need some help with excel. There is this function that you can use to separate a title of a column but you can still scroll down to keep the title on top.

Like for example: http://www.bths.edu/ourpages/auto/2008/3/6...ta.xls?rn=32174

On that you can keep the title "AVG, SATs, etc.." and you can still scroll down to see the info. How can I get that dividing thingy out?


Click on the dividing line and drag it to the top (or left) and it will disappear.
------------------------------------------------------------------------------------------------------------------------
Please note that the opinions posted by me are my own, and not that of the DOE or the Administration, unless specifically mentioned as such.

#3 NickC

    Senior Class President 2010

  • BTHSnews Alumni
  • PipPipPipPipPipPipPipPipPipPipPip
  • 4873 posts
  • Gender:Male
  • Location:Buffalo, NY
  • Major:IAS
  • Class of: 2010
  • Status: Alum
  • College:University at Buffalo

Posted 20 March 2008 - 09:02 PM

OHh I mean, How can I make that thing come out, like I have a page without it, I want to use that function, how can i open that function to use?

Sorry, my question was poorly worded

BTHS Student Government: Senior Class President 2010
International Arts and Sciences
University at Buffalo, the State University of New York '14
Medicinal Chemistry


#4 z2z007

    "The Fury"

  • BTHSnews Alumni
  • PipPipPipPipPipPipPipPipPipPipPipPip
  • 6702 posts
  • Gender:Male
  • Location:Evanston, IL
  • Major:Chemistry
  • Class of: 2006
  • Status: Alum
  • College:Northwestern University (PhD - In progress), Colgate University (AB); University of Manchester

Posted 20 March 2008 - 09:53 PM

Go to the window menu and select split.

#5 NickC

    Senior Class President 2010

  • BTHSnews Alumni
  • PipPipPipPipPipPipPipPipPipPipPip
  • 4873 posts
  • Gender:Male
  • Location:Buffalo, NY
  • Major:IAS
  • Class of: 2010
  • Status: Alum
  • College:University at Buffalo

Posted 20 March 2008 - 11:02 PM

Wow, life saver! Thanks!!!!!!

BTHS Student Government: Senior Class President 2010
International Arts and Sciences
University at Buffalo, the State University of New York '14
Medicinal Chemistry






1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users