As a result, a gray line appears after column B, and two columns before that line are frozen.Then from Excel Ribbon, go to View > Freeze Panes > Freeze Panes.Select the column that is next to the first 2 columns, Here, select column C.Freeze 2 Columns Using Freeze Panes Option in Excelįirst, I will freeze the first two columns using the Freeze Panes option. Now, I will freeze column A and B so that columns having Student Name and ID is visible all the time, even when I scroll the corresponding sheet to the right.ġ. As the dataset contains scores of several tests, scrolling right to the worksheet disappears columns A and B. We have a dataset containing several students’ Names, IDs, Test Scores, etc.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |