![]() ![]() To freeze two rows on the top and two columns on the left at the same time, select cell C3.To freeze the first column and the top row of the worksheet simultaneously, select cell B2,. ![]() To freeze multiple columns on the left, select the column to the right of the last column you want to lock,.To lock the left-most column only, select cell B1 / the entire column B, or use the Freeze First Column option available in the Freeze Panes drop-down menu on the View tab, Can you freeze two separate panes in Excel To lock more than one row or column, or to lock both rows and columns at the same time, choose the View tab, and then click Freeze Panes.To freeze multiple rows on the top, select the row below the last row you want to lock,.In our example, we want to freeze rows 1 and 2, so well select row 3. ![]() Look for Freeze Panes group Click the small arrow and press the. Select the row below the row(s) you want to freeze. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |