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

These 46 Pro Excel Tips Will Transform You Into a Spreadsheet Magician

Microsoft's spreadsheet program can do way more than you might realize. These are the hacks and tricks you need to know.
Computerworld

CTRL keyboard shortcuts for Microsoft Excel 2010

CTRL+PgUp Switches between worksheet tabs, from left-to-right. CTRL+PgDn Switches between worksheet tabs, from right-to-left. CTRL+SHIFT+(Unhides any hidden rows within the selection. CTRL+SHIFT+& ...
How-To Geek on MSN

How to Use the TOCOL and TOROW Functions in Microsoft Excel

The TOCOL and TOROW functions are just two ways to rearrange data in Microsoft Excel. For example, you can flip the rows and ...

MS Excel Slicers Without PivotTables : The Disconnected Table Trick

Learn the secret to building interactive Excel reports with slicers and disconnected tables—no PivotTable needed for dynamic ...

Why Your Excel Tables Are Failing You and How to Fix Them

Learn the secrets of Excel structured tables to save time, eliminate errors, and create smarter, more dynamic spreadsheets.