how can i freeze first two rows in excel

You can cancel the editing mode by pressing Enter or Esc. The Freeze Panes command isn’t available when you are in a cell editing mode (that is, when you’re entering data or a formula in a cell) or when a worksheet is protected.You can’t freeze columns and rows in the middle of the worksheet. You can only freeze the rows at the top and the columns on the left side of your worksheet.How to Freeze Columns and Rowsīefore you decide to freeze columns and rows on a worksheet, it is important that you consider the following factors: The Freeze Panes feature is an excellent way of keeping the data you need readily available rather than wasting time scrolling through columns and rows of data. Fortunately, the Excel Freeze Panes feature can help. Here we discussed How to Freeze Rows in Excel and different methods and shortcuts to Freeze Rows in Excel, along with practical examples and a downloadable excel template.One of the challenges of working with large worksheets is that as you start moving around the worksheets, you’ll lose track of the column heading and row labels.

This has been a guide to Freeze Rows in Excel. Make sure you have selected the right cell to freeze. If you place a cursor in the unknown cell and freeze multiple rows, then you may go wrong in freezing.Make sure the filter is removed while freezing multiple rows at a time.We can freeze the middle row of the excel worksheet as your top row.

You can keep seeing all the 7 rows while scrolling down. This means the above rows are locked or frozen. Now we can see a tiny grey straight line just below the 7 th row. Do not press ALT + W + F + R in a hurry hold on for a moment.Īfter selecting the cell A8 under freeze panes, again select the option Freeze Panes under that.

Step 2: Remember we are not only freezing the top row, but we are freezing multiple rows at a time. This means I want to see all the rows which are there above the 8 th row.

TEXT and String Functions in Excel (26+).

Lookup and Reference Functions in Excel (36+).

Excel Conditional Formatting in Pivot Table.

How can i freeze first two rows in excel