Excel automatically adds a dark grey vertical line to indicate that the first column is frozen. Now when you move around in your spreadsheet, columns and rows should display as normal. Then click on the Unfreeze option in the popup menu. On the View tab, in the Window group, click Freeze Panes. Select the Layout tab from the toolbar at the top of the screen and click on the Freeze Panes button. 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. To freeze the first column, execute the following steps. 760How do I freeze/fix column or row headings in Excel?
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |