While you can easily convert an arranged workbook or part of it from rows to columns using the Transpose function, that isn’t the case when the data is unorganized and spread across a single column.

You use Microsoft Excel 's built-in function to freeze specific rows and columns (often row or column headers), so when you’re scrolling through, these cells remain stationary on the page.

How to freeze multiple rows and columns in Excel You can freeze multiple rows by selecting a cell below the row you want to be fixed in place. The same applies to multiple columns – select the ...