How To Make Top Rows In Excel Stay. Select view > freeze panes >. You should see a darker border under row 1.
Ms Excel New Features
Web select view > freeze panes > freeze panes. Then the top row of current worksheet is frozen and will always stay. Stay in the worksheet you need to make top row always stay visible, then click view > freeze panes > freeze top row. Web click on the freeze panes option found in the window section of the ribbon. You should see a darker border under row 1. Scroll down your sheet to ensure the first row stays locked at the top. Tap view > freeze panes, and then tap the option you need. When you scroll down, row 1. Web click the menu option freeze top row. This will freeze only the top row in your sheet.
Scroll down your sheet to ensure the first row stays locked at the top. You should see a darker border under row 1. Web click the menu option freeze top row. Tap view > freeze panes, and then tap the option you need. Web select view > freeze panes > freeze panes. This will freeze only the top row in your sheet. Select view > freeze panes >. Then the top row of current worksheet is frozen and will always stay. Web if you want the row and column headers always visible when you scroll through your worksheet, you can lock the top row and/or first column. Web click on the freeze panes option found in the window section of the ribbon. Choose the freeze top row option from the menu.
