How To Fix A Row In Excel?

View all

How do I freeze rows and columns in Excel?

Freeze columns and rows

  • Select the cell below the rows and to the right of the columns you want to keep visible when you scroll.
  • Select View > Freeze Panes > Freeze Panes.

How do I keep a row always on top in Excel?

1. Stay in the worksheet you need to make top row always stay visible, then click View > Freeze Panes > Freeze Top Row. See screenshot: Then the top row of current worksheet is frozen and will always stay visible until you unfreeze it.

How do I freeze rows and columns at the same time in Excel 2007?

To freeze the first row and column, open your Excel spreadsheet. Select cell B2. Then select the View tab from the toolbar at the top of the screen and click on the Freeze Panes button in the Window group. Then click on the Freeze Panes option in the popup menu.