How-To Geek on MSN

How to Use the VSTACK and HSTACK Functions in Microsoft Excel

VSTACK and HSTACK are dynamic array functions, meaning the result spills from the cell in which you type the formula, and any changes to the data in the source arrays are reflected in the stacked ...
MUO on MSN

These navigation shortcuts make Excel feel telepathic

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