Use of Rows & Column Freezing in Excel Cell Step 4: As we can see from the snapshot below, two grey lines denote the locking of cells.Step 3: After selecting the cell, we need to click on the “View” tab on the ribbon and select the “Freeze Panes” command on the “View” tab.In our example, we have to choose the cell number H4. We have to select the cell above, besides which we need to freeze the columns and rows cells, respectively. Step 2: We need to see columns “B” and row 7 throughout the worksheet.The columns contain the headers as “Day,” “Date,” “Regular Hours,” “Overtime Hours,” “Sick,” “Vacation,” and “Total.” Step 1: The sheet below shows the timesheet of a company.In addition, It is not necessary to lock only the row or the column at a single instance. It is to be noted that we can also freeze rows and columns together. For example, the “Freeze Top Row” command freezes the row number “1,” and the “Freeze First Column” command freezes the column number A cell. These commands are used only for freezing the top row and the first column, respectively. ![]() In addition, there are two other commands in the “Freeze Panes” options: “Freeze Top Row” and “Freeze First Column.” As we can see in the snapshot below, the columns beside the grey line are frozen and do not move after we scroll the worksheet.įor unfreezing the columns, we must use the same process as we did in the case of rows by using the “Unfreeze Panes” command from the “View” tab. We can scroll the entire worksheet and continue viewing the frozen columns. Step 3: The selected columns get frozen in their position, and a grey line denotes it. ![]() ![]() Then, we need to choose the “Freeze Panes” command on the “View” tab.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |