Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be 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
Joe
Lv 4
Joe asked in Computers & InternetSoftware · 1 decade ago

how do you make a row in Excel always stay on top?

i've seen several spreadsheets that have this done but I can't figure out how to do it. How do you make it so that one row will always stay visible on top?

6 Answers

Relevance
  • Ryan W
    1 decade ago
    Favorite Answer

    Select what you want to stay and click Window--Freeze Panes.

  • aldi
    Lv 4
    5 years ago

    Unfreeze Panes In Excel

    Source(s): https://shrink.im/baM16
  • Mickey Mouse Spears
    Lv 7
    1 decade ago

    If you want row 1 to be on top, select cell A2. Then go to Window --> Freeze Panes.

    If you want rows 1 and 2 to be on top, and column A to remain on the right, select cell B3 and select window-->Freeze Panes.

    To undo it, just go back to Window and select "unfreeze panes".

  • Anonymous
    1 decade ago

    Play around with the Freeze Pane.

  • How do you think about the answers? You can sign in to vote the answer.
  • Abdul khader Hazee
    7 years ago

    Go the Menu Bar on the top --> Click on View -----> then select Freeze Panes

  • Michael
    6 years ago

    HOW TO PRINT A ROW IN EVERY PAGE

Still have questions? Get your answers by asking now.