Looking for a way to make your Excel spreadsheets read more clearly? Why not try freezing some of the rows and columns. Here’s how.

If you right click on one of the worksheet tabs at the bottom and chose "select all sheets", whatever you do on one worksheet is replicated on the others (formatting, data entry etc).<br><br><b ...

Select all the rows or columns that you want to transpose. Press "Ctrl-C" to copy your data to the clipboard. Click on a cell in an unused area of your worksheet.