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

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

Row runs horizontally, and column runs vertically. We explain how to set or change the Row height and Column width in Microsoft Excel.

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.

Adding a new column to either an entire spreadsheet or just a portion is an easy thing to do in Microsoft Excel. Here's how.

Learn how to combine Microsoft Excel’s ROW() and ROUNDUP() functions to create a flexible serial function that returns groups of consecutive values.

You can split cells into columns in Excel using the "Text to Columns" tool, which is a great way to organize lots of data.

If you need to conditionally split values into multiple columns in Microsoft Excel, consider using the IF() function. Here's how.

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

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