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

Find new ideas and classic advice on strategy, innovation and leadership, for global leaders from the world's best business and management experts.

Combining Ctrl + Shift + Arrow keys lets you extend your selection in any direction until Excel hits a blank cell. Start from the top-left corner of your data, try Ctrl + Shift + Right Arrow, then ...