We show you how to put data in alphabetical order in Excel, sorting columns, rows, and using handy shortcuts.

Excel automatically tries to alphabetize vertically by column, but you can easily adjust this setting to sort horizontally by row. Here’s how to do it.

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

First, you need to open the spreadsheet in Excel and Google Sheets. Then, ensure the column or row you want to move or swap with another one and choose the new location as per your requirements ...

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 typical unhiding techniques don't work everywhere in Excel. Learn an easy to remember method for unhiding row 1 and column A.