How to Change Columns Into Rows in Excel 2007. If you've ever entered a long list of business data and realized you need this information across a row instead of down a column, you can take ...

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.

Select the columns you want to fix. In this case we’re selecting the header columns — those at the very top of the ...

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 ...

There are numerous ways to change column widths in Excel, but did you know you can force Excel to do this automatically when you add or remove data? In this example, Excel's default column width ...

The most basic example of a GETPIVOTDATA formula in Microsoft Excel is when the function is used to retrieve a grand total of ...

You can combine two columns in Excel using several formulas and tools available in the software. Here's how to combine two columns in Excel.

Looking for a way to make your Excel spreadsheets read more clearly? Why not try freezing some of the rows and columns. Here’s how.

In this month’s column, find out how to change text strings to sentence case in Excel.

Hiding and then unhiding columns in Excel only takes a few clicks. In this guide, we'll show you how to hide columns and bring them back in no time at all.