I love doing Power Excel Seminars! I was in Fort Wayne, doing a Seminar at a Baseball Stadium, when a question popped up: “If I Double-Click on Sunday, it automatically fills down with Monday, Tuesday, Wednesday. Will your Ctrl key trick work to make it Copy? I don’t want to have to use the pop-up menu to change back to Copy instead of Fill.”
Why was this a great question? Because I had no idea that Double-Clicking a cell would cause the AutoFill to work!
In Episode #1881, you will see how to AutoFill by Double-Click, how to set up a Custom List, a workaround to prevent the AutoFill and make it a Copy *plus* – in the outtake -a Formula using INDEX ROW and MOD together.
…This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill’s book!
And if you’re looking to upgrade to Excel 2013, then check out:
“Microsoft 2013 InDepth” – by Bill Jelen. Excel 2013 In Depth is the beyond-the-basics, beneath-the-surface guide for everyone working with Excel 2013. Excel expert and MVP Bill Jelen provides specific, tested, proven solutions to the problems Excel users run into every day: the types of challenges other books ignore or oversimplify.
Jelen thoroughly covers all facets of working with Excel 2013.
“The Learn Excel from MrExcel Podcast Series”
Visit us: MrExcel.com for all of your Microsoft Excel Needs!