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?

Ryan W2008-11-16T07:32:00Z

Favorite Answer

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

31

aldi2016-09-30T11:25:37Z

Unfreeze Panes In Excel

00

Mickey Mouse Spears2008-11-16T07:32:55Z

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".

41

Anonymous2008-11-16T07:32:25Z

Play around with the Freeze Pane.

12

Abdul khader Hazee2014-07-28T04:11:00Z

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

41
Show more answers (1)

Related Questions

How create static Row in Excel spreadsheet that always stays on a top of the spreadsheet when scrolling down?Microsoft Excel... How do you keep rows always visible at the top?In Excel, how do you freeze panes so that the top column and left row stay with you when you scroll?Trying to get a Microsoft Excel row to stay put?In Excel, how do i lock rows to always be on top of a spread sheet?

Trending Questions

What were your covid 19 vaccine side effects?13 answersCovid 19 face mask?12 answersWhich software is best for editing? ?23 answersDid you like being on lockdown during covid?20 answersWhich one is better? Office 2019 or Office 365?13 answers