( Editor’s note: Excel’s Function Wizard could be recruited to develop the formula. To open the wizard, click on Insert, Function , which evokes a pop-up screen that will walk you through the process.

When you want to fill a column in Excel with a given formula or value, you can do it the old fashioned way (select cells or the column header, CTRL+V ...

However, when you're creating a spreadsheet in Microsoft Excel, the double-click shortcut can be just as useful. In this guide, I'll share 11 of my favorite double-click Excel tricks. After typing a ...

Learn how to work around a couple bugs in Excel to return double values; drill down on lists with anonymous types; and learn the difference between Build and Rebuild.

Calling all spreadsheet jockeys: The Pointy Haired Dilbert blog has seven productivity boosters for Excel, all of them based on double-clicking in places you probably never though to double-click ...