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.