how do you freeze first two rows in excel

How to Protect Excel Sheet with Password.This will remove the formatting change and ‘unlock’ the row and column so that they disappear when you scroll down or across to the right. To undo the formatting, go back to the ‘View’ tab, and in the section ‘Window’ select the option ‘Unfreeze Panes’. The header with months and the column with names are visible all the time now! The data in these cells are still on the screen even though I scroll a bit further down or to the right in the spreadsheet, which makes it much easier to read through and process the data. So, we’ll go for the first option – ‘Freeze Panes’. How to Freeze Only the Left-Hand Column in Excelīut what we want now is to freeze the rows and columns just like we said before. If you want to freeze only the top row or just the left-hand column, go for one of the other options – ‘Freeze Top Row’ or ‘Freeze First Column’. Once you’ve marked the selected cell, click on the tab ‘View’, then go the section ‘Window’ and select ‘Freeze Panes’. The header along with the column with employees’ names will get ‘locked’ in their position on the screen, so you’ll see them all the time, no matter how far into the spreadsheet you scroll. The marking works in the way that all rows above as well as all columns to the left of the marked cell will freeze. It’s the first row and the first column here in our table, and that’s why we click on the cell B2. Let’s scroll back now and see how we can freeze cells.įirst thing, we’ll click on a cell which marks the rows and columns we want to freeze. That’s why we’ve got the function ‘freeze rows/columns’ – to get a clear overview of the information in the table. This way, it might get very hard not to get lost in data. For example, now we cannot see the names of employees anymore. If you keep scrolling down, you might notice that the header – in this case the months – disappears.Īlso, if you scroll across to the right, columns to the left might get out of sight, too. Let’s say you work in a spreadsheet such as this one. Especially with tables containing lots and lots of data. Freezing rows and columns in Excel is an amazingly handy thing.

How do you freeze first two rows in excel