How-To Geek on MSN

How to Use the DROP Function in Microsoft Excel

One of the most underused lookup and reference functions in Microsoft Excel is the DROP function. This powerful yet simple ...
Houston Chronicle

How to Reverse a Column Order in Microsoft Excel

Reversing the order of a column would be easy if the column was already listed alphabetically or sequentially; you would just sort in the other direction. However, data may not be in alphabetical or ...
TechRepublic

How to sort data by multiple columns in Excel

Sorts are a simple task in Microsoft Excel if all you need is an ascending or descending sort. Excel is smart enough that it can interpret the data range. Not all sorts are so easy. Fortunately, Excel ...
How-To Geek on MSN

How to Use the VSTACK and HSTACK Functions in Microsoft Excel

You can use Excel's VSTACK and HSTACK functions to append data in regular cell ranges, Excel tables, or named ranges. into cell E1 stacks the three arrays in the cell ranges A2 to C6, A9 to C13, and ...