Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and the Yahoo Answers website is now in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Trending News

Promoted
Q
Lv 7
Q asked in Computers & InternetSoftware · 1 decade ago

In Excel, how do you get it so that your header row is locked at the top so it is always visible?

no matter how much you scroll down?

Update:

Edited to add: In Excel 2008 for Mac

Update 2:

Edited to add: In Excel 2008 for Mac

3 Answers

Relevance
  • gospieler
    Lv 7
    1 decade ago
    Favorite Answer

    Check this Microsoft Office 2008 tutorial http://www.uwec.edu/help/Excel07/ws-nav-m.htm

    scroll down to Freezing Panes

    For others tutorial check: http://www.uwec.edu/help/excel07.htm

    TIP: Excel 2008 is the Mac version of windows 2007. The features and how to do it is the same. The only difference is the operating system where you install the office suite

  • Robert
    Lv 6
    1 decade ago

    Use "Freeze Frames" Select the cell to the right and below the header row. Then select "window" then "Freeze Frames"

  • pete l
    Lv 6
    1 decade ago

    in the menu bar

    VIEW>> FREEZE PANES>> FREEZE TOP ROW

Still have questions? Get your answers by asking now.