![]() Then click Freeze Panes from the drop-down menu.In the Window section of the ribbon's View tab, click Freeze Panes ▼.Click in the cell immediately below the row(s) AND to the right of the column(s) to be frozen-cell C3 in our sample worksheet.(If it isn't, freeze panes won't work correctly) Make sure cell A1 displays in the Excel window. ![]() The first spreadsheet above has single row and column headings, while the second has multiple. Most large worksheets require row AND column panes be frozen. If we scroll both vertically and horizontally as shown below, the data becomes meaningless.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |