![]() Typically, you would want to lock the first row to see the column headers when you scroll down the sheet. Bellow you will find the detailed steps for Excel 2016, 2013, 2010 and lower versions. In Microsoft Excel terms, to freeze panes means to always show certain rows and/or columns at the top of a spreadsheet when scrolling. ![]() The good news is that you can easily fix that inconvenience by freezing panes in Excel. Hardly anyone will ever use them to the limit, but if your worksheet contains tens or hundreds of rows, the column headers in the top row disappear when you are scrolling down to view lower entries. These tips work in all modern versions of Excel 2016, 2013, 20.Īs you probably know, the recent versions of Excel 2016, 20 allow using more than a million rows and over 16,000 columns per sheet. You will also see how to freeze several panes at a time to make Excel always show certain rows or/and columns when you scroll down or right. You will learn how to quickly lock header row or/and the first column. The tutorial demonstrates quick ways to freeze panes in Excel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |