If some of the rows are out of view, such rows will be subconscious after freezing. Brand sure that all the rows to exist locked are visible at the moment of freezing.It is not possible to lock rows in the eye of the sheet. Select the row (or the get-go jail cell in the row) right below the last row you want to freeze.įor example, to freeze pinnacle two rows in Excel, nosotros select cell A3 or the entire row iii, and clickĪs the result, yous’ll be able to scroll through the sheet content while standing to view the frozen cells in the first 2 rows:.In case you want to lock several rows (starting with row 1), comport out these steps: Yous can make up one’s mind that the top row is frozen by a greyness line beneath it: This will lock the very first row in your worksheet so that information technology remains visible when you navigate through the rest of your worksheet. You simply clickĪnd choose one of the post-obit options, depending on how many rows yous wish to lock: Other ways to lock columns and rows in Excelįreezing rows in Excel is a few clicks thing.This tin can exist hands done by using theĬontrol and a few other features of Excel. When working with big datasets in Excel, you may often want to lock certain rows or columns and then that you lot can view their contents while scrolling to another area of the worksheet. Beneath you will find the detailed steps on how to lock a row or multiple rows, freeze one or more than columns, or freeze cavalcade and row at once.
The tutorial shows how to freeze cells in Excel to keep them visible while yous navigate to another area of the worksheet.
0 kommentar(er)
