How-To Geek on MSN

I Use the Arrow Keys More Than Any Other Keys in Excel

Here are the best uses of the Arrow keys in Excel with Scroll Lock mode turned on. Pressing Ctrl+Shift+Up, Down, Left, or Right Arrows selects the current cell and all cells above, below, to the left, ...
MUO on MSN

I use Excel's TAKE and DROP to make top-10 lists that update themselves

Here's how Excel processes that request. First, the SORT function arranges the entire table by sales amount in descending ...