Excel Magic Trick 1461: Ctrl + Enter or Ctrl + D, What is the Difference and When to Use Each?

About this tutorial:

Video duration: 4:8
Excel, Excel 2016, Highline College, Mike Girvin, excelisfun, Excel Magic Trick, Ctrl + D, Ctrl + Enter, Copy Quickly Down Column, Excel keyboard shortcuts, Copy Formula Down Column, Excel Keyboards, Keyboard shortcuts in Excel, What does Ctrl + Enter Do?, What does Ctrl + D do?, Excel Ctrl Enter, Excel Ctrl D, Fill Down, Populate highlighted cells with edited formula

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

24 thoughts on “Excel Magic Trick 1461: Ctrl + Enter or Ctrl + D, What is the Difference and When to Use Each?

    Felix Chee

    (October 8, 2019 - 9:08 pm)

    Weird.. instead of copying the formula, when i click ctrl D, all the other cells answer following the first cell instead of the formula.

    Don Mega

    (October 8, 2019 - 9:08 pm)

    how would i populate the formula =P3*Formulas!B3 down to all the cells so it would become =P4*Formulas!B3 in the next and =P5*Formulas!B3 in the next and so on? thanks!

    Ahmed AlKhabouRi

    (October 8, 2019 - 9:08 pm)

    Well I need some help an I hope you can assist me and those who have similar question
    I have a data set , where on of it columns indicates how many time it should be repeated ( row repeated)
    e.g I have several building which maximum building has
    10 flats, each flat will have same: name, address, location, but different number
    So can you help in this. I tried adding columns depending on maximum number of flat then pivot the them fill and combine same .. But I don't know how to code power query yet!


    (October 8, 2019 - 9:08 pm)

    Great again. "That wasted a click?". I am longing for the vid to avoid half a click.

    Manas Behera

    (October 8, 2019 - 9:08 pm)

    sir i see each and every videos of yours.now i m facing one problem. if my data table in sheet 1,when i will put some data in sheet 2 that will automatically added to the lower column of sheet 1 table .plz sir make a video on this problem..

    Excel Elewa

    (October 8, 2019 - 9:08 pm)

    My name is Excel

    Angela Zhang

    (October 8, 2019 - 9:08 pm)

    Hi, you have always posted so good video and very helpful. Do you provide any private lesson for powerpivot and powerquery? your contact? Thanks.

    Claire Squibb

    (October 8, 2019 - 9:08 pm)

    Loved this – the last bit about using Ctrl-D to copy "to the bottom" of a list of unknown size in a macro is something that hadn't occurred to me. Many thanks, that'll make a common problem a lot easier to deal with!


    (October 8, 2019 - 9:08 pm)

    That wasted a click…
    Amazing… To your calculations…

    Leila Gharani

    (October 8, 2019 - 9:08 pm)

    I am now proud to be in the minority (after watching of course). Thanks for this great video. One other minor difference between Ctrl+D and F2+Ctrl+Enter is that Ctrl+D copies the formatting (of that first cell) whereas Ctrl+Enter just copies the formulas. Thank you!

    Shareef Kuzhikkattil

    (October 8, 2019 - 9:08 pm)

    Dear Mike, thanks for your lesson, when am using the cntrl + Enter, it doesn't work for me, i have tried more than ten times, please let me know if there is any alternative way use both..

    Covis KK

    (October 8, 2019 - 9:08 pm)

    I learned Ctr+Enter from one of your very early posts. Video 1 or 2 or 3. Now we are 1461. It's amazing how often I need it. Like every 2nd time I edit a cell.

    Mohamed Chakroun

    (October 8, 2019 - 9:08 pm)

    Thank you Mike

    sjn 72

    (October 8, 2019 - 9:08 pm)

    After watching your videos for years I'm now firmly in the ctrl-enter zone. Took about as long as it took to break the two spaces after a period habit :).

    Adam Bk

    (October 8, 2019 - 9:08 pm)

    Simple yet effective

    Steve Morris

    (October 8, 2019 - 9:08 pm)

    Ctrl D is new to me 🙂
    Shift Enter will jump up a cell after entering the formula or value which can come in useful too!


    (October 8, 2019 - 9:08 pm)

    Thanks for the great video!

    Syed Muzammil Mahasan Shahi

    (October 8, 2019 - 9:08 pm)

    Wow. That's brilliant. I never knew this one before. Thanks for such a wonderful video.

    Excel On Fire

    (October 8, 2019 - 9:08 pm)

    One day I'll remember CTRL+Enter

    eCabinets tips and tricks

    (October 8, 2019 - 9:08 pm)

    Awesome!! Thanks Mike.

    Haytham Khalil

    (October 8, 2019 - 9:08 pm)

    Hi Mr. Mike. I would like to thank you very much for all our very useful lessons in Excel. I wish you more and progress in your scientific and practical life.
    I have a question and I hope you have the answer, about the pivot tables
    Can I create a statement of account based on the date, the start date in cell and the end date in another cell

    John Borg

    (October 8, 2019 - 9:08 pm)

    Always Learning something new !!! Ctrl + D and when you have the bottom cell selected too. I used to highlight the cells from bottom to the top, Press Ctrl + . to bring the active cell to the top press F2 and Ctrl + Enter. AMAZING and thanks Mike 🙂

    5ub Zer0

    (October 8, 2019 - 9:08 pm)

    I have graduated from the Vast Majority. Mind Blown! Thanks again for a a great instruction without fluff.

    chinna k

    (October 8, 2019 - 9:08 pm)

    please post a VBA tutorials also , u r teaching style is totally amazing I have learned a lot of excel skills in your YouTube channel thx a lot to posting valuable excel videos ….

Leave a Reply

Your email address will not be published. Required fields are marked *