Learn how to Transpose Row to Column in Excel. Transpose converts horizontal row data sheets into vertical column style sheets and back.

Occasionally you may have a worksheet with data in columns that you want to rearrange into rows. Instead of reentering the data, you can easily rotate the data using the Transpose feature. The ...

Excel’s BYCOL() and BYROW() functions evaluate data across columns and rows, returning an array result set allowing you to bypass a lot of work.

The larger a spreadsheet gets, the more likely you'll want to start hiding rows or columns or maybe you've been given a sheet that has hidden rows or columns.

Freezing a row in Microsoft Excel or Google Sheets can organize your spreadsheet and make sorting through data a breeze. Here's how to do it.