you can check the result in the picture below. now choose the freeze panes command and pick the freeze panes option from the menu. select the row you want to freeze, in this case, row 1. for example, to freeze the top row and first column, select cell b2, go to the view tab and click freeze panes under freeze panes: in the same fashion, you can freeze as many excel panes as you want. To lock several rows and columns at a time, select a cell below the last row and to the right of the last column you want to freeze. note: to keep the first column visible while scrolling through the right of the worksheet, click freeze first column. excel automatically adds a dark grey horizontal line to indicate that the top row is frozen. ![]() scroll down to the rest of the worksheet. ![]() On the view tab, in the window group, click freeze panes. excel functions (alphabetical) excel functions (by category). ![]() split panes to lock rows or columns in separate worksheet areas. ![]() Freeze panes to lock the first row or column in excel 2016 for mac.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |