Top Excel Power Shortcut #3: Copying formulas or data in a column

We’re very excited about our upcoming course, Excel 2010 Power Shortcuts with Dennis Taylor, that’s due to be released soon—so excited that we’ve decided to give you a sneak peek at some of his top power shortcuts. Here’s the third shortcut:

In Excel, if you want to copy a formula or data down a column, you don’t need to copy and paste or even drag—a difficult task if you have thousands of rows of data. This time-saving shortcut shows how you can copy text or a formula down a column in an instant. If you’re already familiar with this shortcut, this video shows how it is improved in Excel 2010.