Episode # 692 - Ditto

Copy the exact formula from above using Ctrl+' or Ctrl+"

Sponsored by

Learn Excel from MrExcel

Check out this book for more tips
similar to this lesson!

If you need to copy the *exact* formula from the cell above, there is an amazing shortcut key that will copy this formula down one row. I mean...the exact formula...not a formula with different references, but the exact formula. Episode 692 shows you how. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

You don't need to go spend an entire day at the local computer chain store to learn Excel. Take 2 minutes to learn this lesson now with our free video!

Watch Video

Click Play icon to play the video. You might first need to click on the Video to activate Flash player.

Tags/Keywords for this video: Excel, business, accounting, spreadsheets, tutorial, technology, MrExcel

More Excel Video Lessons

If you like this video, there are hundreds of 2-5 minute videos available here: