Using the Excel Text to Column feature, you can choose how to split the column up, fix the width, or split at each comma, period, or other characters.

How to Use Column Headings in Excel. For many small business owners, Microsoft Excel 2010 is not only a powerful tool for internal tracking and bookkeeping, but it can also be used to prepare ...

Using the Text to Columns Tool One way to split data into multiple columns in Microsoft Excel is to use the built-in Text To Columns tool. This method is handy if you prefer to work in a dialog ...

Want to transpose Rows into Columns in Excel or Google Sheets? This post shows how to switch or swap Columns and Rows in Excel and Google Sheets.

How to Give a Name to the Columns in Excel. The default method for including a column reference in an Excel formula is to use the column letter, a convention that may make it difficult to ...

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

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 ability to move columns in Excel is a great benefit when dealing with long strands of data in Excel. Here's how to do it.

You can freeze columns in Excel with a few clicks, and then unfreeze them when you no longer need to view them statically.

In this guide, you'll learn how to freeze top 2 rows in your Microsoft Excel spreadsheet and keep headers visible while ...