how to freeze a row in excel

Open the workbook in excel (Ctrl+O). Move to cell A1, insert the formula = IF(A11>K2 AND K2<M3)
(Alternate version: User’s solution: http:\/\/\/diversos-momentos-eliminados-carto for Excel 2007 and Excel 2010) By referring practice to websites, I found this wiki page . Paste the formula all around the columns where value should be 0, row above 1 and column below 1. For example:This is an article I’m reading. Let’s watch it titled: how to freeze a row in excel. If you have any questions, please reply back.

How to freeze rows in Excel?

Freeze rows or columns 1 Select the cell below the rows and to the right of the columns you want to keep visible when you scroll. 2 Select View &gt; Freeze Panes &gt; Freeze Panes.

How to keep a section of a worksheet visible?

To keep an area of a worksheet visible while you scroll to another area of the worksheet, go to the View tab, where you can Freeze Panes to lock specific rows and columns in place, or you can Split panes to create separate windows of the same worksheet.