To do this, select the column or a cell just to the top right of the columns you wish to freeze. You can also freeze more than one column. If you want to freeze or lock the first column only, go the View tab and select Freeze Panes > Freeze First Column.Īfter you do this, the leftmost column in your spreadsheet will remain frozen as you scroll to the right. You can also freeze columns in Excel, and the operation is similar to the way you freeze rows. Note: Excel only allows you to freeze rows at the top of your spreadsheet and not ones in the middle. Then go the View tab and click Freeze Panes > Freeze Panes. For example, if you want to freeze the first two rows, go to cell A3. To do this, navigate to the first cell or row below the ones you want to freeze. You can also freeze multiple rows in Excel. Your top row (Row 1) will now have a grey line below it, which indicates that it has been frozen or locked. To do this, go to the View tab in Excel, and select Freeze Panes > Freeze Top Row. This way, when you scroll down through hundreds of rows, you’ll still have those headings at the top to give you the information you need. You may want to freeze the top row in Excel because it holds your column titles. Which clicks you use will depend on what you want to do – freeze the top panes only or a group of several rows. You can freeze rows in Excel with just a few clicks. Learn the basics of freezing rows and columns in Excel to control your view of data.
0 Comments
Leave a Reply. |