how can i freeze first two rows in excel

For example, Excel won't allow you to lock rows on a protected worksheet or if you're working in cell editing mode, such as when you're adding data into a cell or entering a formula. Excel may prevent you from locking a row in certain circumstances. This indicates you've locked the row and ensures that it stays in the same place as you scroll through the worksheet. Once you lock a row, Excel adds a solid line beneath it. While there's no limit to the number of rows you can lock in Excel, you can only lock rows at the top of a given spreadsheet, and the program requires you to lock the first row. Locking a row in Excel can allow you to keep important information in view as you navigate large amounts of data. What is a locked row in Excel?Ī locked row in Excel is a horizontal section of a spreadsheet that remains visible even if you scroll to another section. In this article, we define what a locked row in Excel is, explain how to lock a row in Excel, discuss the benefits of doing so and describe how to unlock a row after entering your data in the spreadsheet. Learning how to lock a row in Excel can help you better manage and navigate your spreadsheet. If you frequently work with large data sets, Excel can help you better keep track of different rows of information by allowing you to lock or freeze rows in place. Excel is a computer program that allows you to create spreadsheets to organize, interpret and analyze data.

How can i freeze first two rows in excel