{"id":168637,"date":"2021-05-31T10:27:39","date_gmt":"2021-05-31T08:27:39","guid":{"rendered":"http:\/\/sftarticles.wpenginepowered.com\/en\/?p=168637"},"modified":"2025-07-01T21:05:21","modified_gmt":"2025-07-02T04:05:21","slug":"microsoft-excel-how-to-freeze-a-row-in-2-fast-methods","status":"publish","type":"post","link":"https:\/\/cms-articles.softonic.io\/en\/microsoft-excel-how-to-freeze-a-row-in-2-fast-methods\/","title":{"rendered":"Microsoft Excel: How to Freeze a Row in 2 Fast Methods"},"content":{"rendered":"\n

Reading large spreadsheets can get tricky, as the usual drill requires you to keep the first few rows or columns frozen for easier use. However, you don’t have to call Sub-Zero to freeze rows in Excel<\/a>. <\/p>\n\n\n\n

Our article gives you a few other, less menacing methods.<\/p>\n\n\n

  1. Freeze top row or first column<\/h2>\"How

    Excel’s functionality includes the first row and first column freezing as a default in the “Freeze Panes” dropdown menu. To access it, you need to go to the spreadsheet, click the “View” menu, navigate to “Freeze Panes,” and click the arrow.<\/span><\/p>\n

    You’ll see three choices. The bottom two are referring to the “First Row” and “First Column.” You can choose one, the other, or both.<\/span><\/p>\n<\/div><\/li>

  2. Fix rows and columns<\/h2>\"How

    There might be cases where freezing the first row and column isn’t enough. To ensure convenience, you can also suspend more than one of them. To freeze more than one row, follow the steps below:<\/span><\/p>\n

    – Click the row below what you want visible at a scroll<\/span><\/p>\n

    – Go to View > Freeze Panes<\/span><\/p>\n

    – Choose the top option<\/span><\/p>\n

    The same trick works for the columns:<\/span><\/p>\n

    – Click a column to the right of what you want frozen<\/span><\/p>\n

    – Go to View > Freeze Panes<\/span><\/p>\n

    – Click the unspecified panes option on top of the list<\/span><\/p>\n

    You can also halt columns and rows at the same time. Just click a tile, and go to the “Freeze Panes” selection mentioned above. Once you click, all the rows above and columns to the left of the selected tile will stay in place.<\/span><\/p>\n<\/div><\/li><\/ol><\/div>