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

Published by | Wednesday, August 11th, 2010

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.

Did you miss the first two top shortcuts? Watch Top Excel Power Shortcut #1: Entering the same data into nonadjacent cells and Top Excel Power Shortcut #2: Converting formulas to values.

Share this:Share on Facebook17Tweet about this on Twitter2Share on Google+0Pin on Pinterest0Share on LinkedIn0

lynda.com - start learning today

Tags: , , ,


10 Responses to “Top Excel Power Shortcut #3: Copying formulas or data in a column”

  1. John says:

    OMG What a time saver. I had almost a million rows and found your podcast on copying formulas down a worksheet. Thanks for the tip on line. It saved me a lot of time and effort.

  2. Marie-Louise says:

    THANK YOU!

  3. Peter K says:

    thanks :)

  4. Tanisha B. says:

    Awesome tip. I wish I new this years ago. Usually I use the copy and shift.command.down function and it goes ALL the way down to the last row. Using this formula, it eliminates me checking the copying stop where the data ended.

    thanks.

  5. Jim G says:

    i was wondering if that could be worked into a VBA script somehow?

  6. Dottie K says:

    Fabulous short cut for coping formulas. Has just saved me tons of time. Thanks

  7. T Solomon says:

    This doesn’t seem to be working for me. Is it a mac/PC issue? I’m on Excel for Mac 2011

    • Hi, Tabitha- Alas, no- although you can drag the right corner of a cell to copy its formula down a row in Mac Excel 2011, the double-click shortcut shown in this video only works in the Windows versions, Excel 2010 (and greater).

  8. James Pyle says:

    Not sure why but this never works for me..double clicking does nothing.

  9. van says:

    VERY VERY USEFUL! Thanks !!!

Leave a Reply