Microsoft designed Excel with a method for naming cell ranges and columns to simplify writing and interpreting formulas. You can apply column names to a single worksheet or increase the scope and ...

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

Open the Excel worksheet for which you want to alter the column width. Click on the Home tab in the Excel ribbon. Go to the Cells group and click on the "Format" icon to reveal the Cell Size menu.

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

Learn how to change, edit or rename a Data Series name in Microsoft Excel Graph or Chart without editing the original row or column name.

In Excel 2007, press Alt, which puts Excel into a shortcut key mode (see the January 2009 column, page 74, for more on the use of KeyTips) and press H for the Home tab of the Ribbon. Press O (capital ...

Microsoft Excel’s AutoFit feature is great when you need to resize a cell to display more text than the cell currently allows. But when you can’t change the size of a cell to fit the text ...