![]() ![]() Lines will appear on your spreadsheet separating out the frozen columns and rows from the scrollable part of your spreadsheet. Go to the View tab, and click Freeze Panes. After freezing a row or column in excel, a grey line appears at the end of the frozen area. Now, navigate to the View tab in the Excel Ribbon as shown in above image. Freeze first columnIt freezes only the first column. Open the sheet where in you want to freeze any row / header, as an example we would like to freeze the top row highlighted in yellow. Freeze top rowIt freezes only the first row. If I had selected B3, the top two rows and first column would be frozen. Freeze panesIt freezes multiple rows and columns. 760How do I freeze/fix column or row headings in Excel? In my example, I want to freeze the top row and the first column, so I click on cell B2.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |