To unfreeze the frozen panes, the same procedure may be used too. Add the freeze panes option to the quick access toolbar and use it as a shortcut key to freeze the panes. For it to be more efficient, you can add it to the quick access area by clicking on the down arrow and then clicking on the commands. The magic freeze button is a software shortcut key that allows you to easily freeze the rows and columns. Select the top row or the first column where you want the splitįreezing the first row and the first column can be done efficiently by splitting the panes or freezing the panes so that one can work and scroll comfortably in the excel worksheet with the cells of the top row and the first column being visible. You can When scrolling in one area, the cells in the other areas remain fixed.ġ. ![]() Splitting panes will divide the excel window into two or four areas. Splitting panesīesides freezing panes, splitting panes can also be used to freeze the top row and the first column in excel. This makes it easy when navigating the spreadsheet. Moreover, a faint line may also appear, indicating that the top row and the first column are frozen. To realize that the cells have been frozen, the border under the top row and the first column will be slightly darker, indicating that the first row and the first column are frozen. Click on the Freeze Panes drop-down arrow in the Window group. Next, click on the View tab in the ribbon. In the windows group, go to the “View” tab To freeze rows and columns in Microsoft Excel: Select the cell in the row below the row you want to freeze and the cell in the column to the right of the column you want to freeze. To successfully freeze the top row and the first column, the following steps should be followed. Freezing the top row means that the top row will be locked, and it will remain visible when you navigate through the worksheet.įreezing the first column means that the column remains visible when navigating the worksheet. ![]() Trouble-freezing is the best way to use when one wants to freeze the first column and the top row. If you select cell B2, and under 'View,' choose 'Freeze Panes,' the first column AND row will be frozen simultaneously.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |