How to Lock Row and Column Separately/Together in Excel: It’s very simple to sort or filter row and column heading at the same time in excel. You can lock multiple rows and column together in Excel.

To keep an area of a worksheet visible while you scroll to another area of the worksheet, go to the View tab, where you can Freeze Panes to lock specific rows and columns in place, or you can Split panes to create separate windows of the same worksheet.

Please take the opportunity to connect and share this video with your friends and family if you find it useful.