Notice the heavier lines around the locked rows and columns. The image above shows our worksheet with the frozen panes, which we've highlighted in yellow. 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. Click Freeze First Column to keep Column A visible while scrolling left or right.Click Freeze Top Row to keep Row 1 visible while scrolling up and down, or.In the Window section of the ribbon's View tab, click Freeze Panes ▼ as shown above.(If it isn't, freeze panes won't work correctly.) Screenshots of our frozen panes, highlighted, follow:
0 kommentar(er)
