The Transpose feature allows you to rotate data from columns to rows and vice versa from rows to columns without reentering any of the data.

Got a whole bunch of data in a row or column that needs to be sorted alphabetically? You can do it with just a few clicks in Excel.

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.

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.