![]() ![]() If some of the rows are out of view, such rows will be hidden after freezing.įreezing columns in Excel is done similarly by using the Freeze Panes commands. Make sure that all the rows to be locked are visible at the moment of freezing.It is not possible to lock rows in the middle of the sheet. Microsoft Excel allows freezing only rows at the top of the spreadsheet.On the View tab, click Freeze Panes > Freeze Panes.įor example, to freeze top two rows in Excel, we select cell A3 or the entire row 3, and click Freeze Panes:Īs the result, you'll be able to scroll through the sheet content while continuing to view the frozen cells in the first two rows:.Select the row (or the first cell in the row) right below the last row you want to freeze.In case you want to lock several rows (starting with row 1), carry out these steps: You can determine that the top row is frozen by a grey line below it: This will lock the very first row in your worksheet so that it remains visible when you navigate through the rest of your worksheet. ![]() To lock top row in Excel, go to the View tab, Window group, and click Freeze Panes > Freeze Top Row. Freeze Top Row - to lock the first row.You just click View tab > Freeze Panes and choose one of the following options, depending on how many rows you wish to lock: Freezing rows in Excel is a few clicks thing. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |