Click Freeze Top Row or Freeze First Column. A set of three freezing options will appear. When you work with a large Excel worksheet, it's often difficult to remember exactly what kind of data, columns or rows contain once you begin scrolling around the sheet. Its in the 'Window' section of the toolbar. Choose Format as Table from the Styles section of the Home ribbon, and then choose a color scheme, as shown in Figure 1. ![]() And now, the top row has been frozen, you just need to scroll the top window, both top row and bottom row are be viewed at once. Select a single cell within your list of data. After freeze the bottom row, now, you need to freeze the top row in the above worksheet, please click one cell in the above window, and click View > Freeze Panes > Freeze Top Row, see screenshot: 6. You might want to experiment on a large worksheet. ![]() On the View tab, in the Window group, click Freeze Panes, and then click the option that you want. To remove the split, simply double click the split bar. To change the window layout, use the horizontal split bar that divides the panes. ![]() As you can see, the first 6 rows remain visible. For example, use the lower vertical scroll bar to move to row 49. To lock both rows and columns, click the cell below and to the right of where you want the split to appear. On the View tab, in the Window group, click Split. 760How do I freeze/fix column or row headings in Excel? If you click in cell C1 and click on VIEW then go to FREEZE PANES and choose the first option that should freeze columns A & B. Its easy to change the color of every other row in an Excel 2007 or Excel 2010 worksheet: 1. To lock columns, select the column to the right of where you want the split to appear.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |