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

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.

Microsoft Excel’s Advanced Filter feature displays records that match specific criteria. You can also limit the columns returned by this feature.

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