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

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.

The purpose of the Convert Text to columns wizard is to separate the content of one excel cell into separate cells. You can set the delimiters that your data contain and set the column data format.

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.

A row-by-row formatting rule is as easy to apply as a column-by-column in Microsoft Excel, but you might not get the results you thought you would.

Data mining your general ledger with Excel Learn how to use Microsoft’s ubiquitous spreadsheet application to unlock the wealth of information stored in your company’s financials.

The typical unhiding techniques don't work everywhere in Excel. Learn an easy to remember method for unhiding row 1 and column A.

I will show you how to take a workbook in Excel and go through each spreadsheet in the file and search for data that not only shows you the data, but also the row and column number that it is located ...