• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

  • Courses
  • Pricing
    • Free Courses
    • Power BI Course
    • Excel Power Query Course
    • Power Pivot and DAX Course
    • Excel Dashboard Course
    • Excel PivotTable Course – Quick Start
    • Advanced Excel Formulas Course
    • Excel Expert Advanced Excel Training
    • Excel Tables Course
    • Excel, Word, Outlook
    • Financial Modelling Course
    • Excel PivotTable Course
    • Excel for Customer Service Professionals
    • Excel for Operations Management Course
    • Excel for Decision Making Under Uncertainty Course
    • Excel for Finance Course
    • Excel Analysis ToolPak Course
    • Multi-User Pricing
  • Resources
    • Free Downloads
    • Excel Functions Explained
    • Excel Formulas
    • Excel Add-ins
    • IF Function
      • Excel IF Statement Explained
      • Excel IF AND OR Functions
      • IF Formula Builder
    • Time & Dates in Excel
      • Excel Date & Time
      • Calculating Time in Excel
      • Excel Time Calculation Tricks
      • Excel Date and Time Formatting
    • Excel Keyboard Shortcuts
    • Excel Custom Number Format Guide
    • Pivot Tables Guide
    • VLOOKUP Guide
    • ALT Codes
    • Excel VBA & Macros
    • Excel User Forms
    • VBA String Functions
  • Members
    • Login
  • Blog
  • Excel Webinars
  • Excel Forum
    • Register as Forum Member

Shortcut for Duplicating Formulae, Text and Objects in Excel

You are here: Home / Excel Shortcuts / Shortcut for Duplicating Formulae, Text and Objects in Excel
Duplicate formula, text and objects
February 22, 2018 by Philip Treacy

If you want to duplicate something you can copy (CTRL+C) and paste (CTRL+V). But there's a quicker way that only requires one shortcut: CTRL+D.

Now you can work twice as fast 🙂

CTRL+D to Duplicate

You can use CTRL+D to duplicate formulae, text, shapes, charts, smart art, pictures or pretty much anything you can select.


Formulae

With a formula, select the cell you want to copy, then drag down to select the cells you want to duplicate the formula into.

Press CTRL+D and your formula is duplicated into each cell in your selection.

duplicating formula in single column

Duplicating like this only works from top to bottom, so whatever is in the top-most cell of your selection is duplicated.

It does work with multiple columns though

duplicating multiple columns


Duplicating Into a Single Cell

If you just want to duplicate a single cell into the one below it, you can just select the target cell and press CTRL+D.

duplicating single cell


Text

Duplicating text works exactly the same as with a formula.

duplicating text


Duplicating Objects

You can duplicate shapes, charts, smart art, pictures etc. Just click on the object to select it, then press CTRL+D.

Charts

duplicating a chart


Shapes

duplicating a shape



More Shortcuts

You can learn over 200 Excel shortcuts here and download a PDF for handy reference.

Duplicate formula, text and objects

More Excel Shortcuts Posts

double click shortcuts thumbnail

Hidden Excel Double Click Shortcuts

There are a load of hidden Excel double click shortcuts that will streamline the way you work in Excel and save loads of time
autosum

AutoSUM Shortcut in Excel

Learn multiple useful ways to use the AutoSUM shortcut in Excel. You'll never have to click on that AutoSUM icon in the Ribbon ever again.


Category: Excel Shortcuts
Previous Post:excel infographicExcel Infographics
Next Post:AutoSUM Shortcut in Excelautosum

Reader Interactions

Comments

  1. Gurudevaa

    November 13, 2022 at 11:48 am

    HELP ME
    How to check repeated numbers when we key in

    Reply
    • Mynda Treacy

      November 13, 2022 at 12:47 pm

      You can use conditional formatting to automatically highlight cells that contain the same values as other cells. If you get stuck, please post your question on our Excel forum where you can also upload a sample file and we can help you further.

      Reply
  2. Hendy

    September 17, 2021 at 1:19 pm

    Hallo

    Example Result
    1 1
    1
    1
    2 2
    3 3
    3
    3

    can you help me how to duplicated multiple cells at once with above case? instead of manual CTRL + D one by one.

    Thanks

    Reply
    • Mynda Treacy

      September 17, 2021 at 1:48 pm

      Hi Hendy,

      I’m not sure what the pattern is here and how I’d write some logic to tell Excel what to do. Please post your question on our Excel forum where you can also upload a sample file explaining in more detail and we can help you further.

      Mynda

      Reply
    • Rathindra Nath Mukherjee

      January 19, 2023 at 9:31 am

      Hi Hendy,
      You can select multiple columns that you wish to duplicate. Once all the columns and rows are selected, use command CTRL G, click on special, choose radio button ‘Blanks’ and press enter.
      This will highlight all the blanks cells in your selection. Then on the second row A2 (that copies value from the first row in selection, A1) write =A1 and press CTRL Enter. This will duplicate the required values.

      Reply
  3. Gary

    February 28, 2018 at 6:37 pm

    Great tip. Will this work when a filter is applied and the rows are not consecutive? If there a work around for this if not? Thanks

    Reply
    • Catalin Bombea

      March 2, 2018 at 2:11 pm

      Hi Gary,
      Never tried that, can you please try and let us know how it works?
      As for a workaround, I’m afraid that the only alternative to a shortcut is manual work…
      Have you seen this tutorial?

      Reply
      • Gary

        March 10, 2018 at 3:47 am

        I have now tried it in the scenario I enquirer about and it works a treat. Thanks for the tip.

        Reply
        • Catalin Bombea

          March 10, 2018 at 3:00 pm

          Thanks for feedback Gary 🙂

          Reply
  4. Jeff Weir

    February 26, 2018 at 7:10 am

    That’s a new one on me. Awesome little productivity hack.

    Reply
    • Philip Treacy

      February 26, 2018 at 8:44 am

      Thanks Jeff

      Reply
  5. Stephen

    February 23, 2018 at 3:52 pm

    I’ve often used Ctrl+D for duplicating objects (also works in other applications), but had forgotten about its use for copying down.

    Thanks for this reminder 🙂

    Reply
    • Philip Treacy

      February 23, 2018 at 7:10 pm

      You’re welcome

      Reply
  6. Joan

    February 23, 2018 at 5:37 am

    I love the Duplicate (Ctrl + D) function. Thanks for all your wonderful posts!

    Reply
    • Philip Treacy

      February 23, 2018 at 1:28 pm

      You’re welcome.

      Reply
  7. Rachael

    February 23, 2018 at 5:08 am

    Thanks Phil, a useful tip … I’ve been using Excel ‘a while’ now and never knew about this

    Reply
    • Philip Treacy

      February 23, 2018 at 1:29 pm

      No worries.

      Reply
  8. Lyn McCormack

    February 23, 2018 at 3:40 am

    How is the CTRL D option different from using the copy and paste method (CTRL C & CTRL V)? I’m a keyboard shortcut fanatic, not a mouser, so I don’t see it as faster from your blog examples, are there any other advantages to memorizing CTRL D as an alternative? Using it to copy an image multiple times is the only one I can see. Looking forward to learning more. Thank you.

    Reply
    • Philip Treacy

      February 23, 2018 at 1:33 pm

      Hi Lyn,

      If you select something then press CTRL+C followed by CTRL+V, that’s 2 keystrokes/shortcuts to copy/duplicate it.

      If you select something and press CTRL+D that’s one keystroke to duplicate it. Isn’t that faster?

      I often have to duplicate shapes or charts and CTRL+D does that for me.

      Regards

      Phil

      Reply
  9. jim

    February 22, 2018 at 11:47 pm

    If you’re dragging down to select a range to ctrl-D, then you may as well use the fill handle
    I do use this shortcut (and its horizontal sister ctrl-R) quite often though to copy down from above immediately after inserting a new row
    Also worth mentioning are:
    ctrl-‘ , which will copy the formula from above and leave the cursor in the cell ready to edit
    ctrl-” , which copies the value from above and also leaves you editing the cell
    these latter two don’t copy formats whereas ctrl-D (and ctrl-R) do – and they only work on the current cell

    Didn’t know about using ctrl-D to copy objects though – thanks for that (and if you have a shape selected then ctrl-R will start editing its text – a new discovery!)

    jim

    Reply
    • Philip Treacy

      February 23, 2018 at 1:34 pm

      Thanks Jim, nice tips!

      Reply
  10. Alex B

    February 22, 2018 at 11:04 pm

    And Ctrl+R does the same as the above but to the Right instead of Down.
    (Only down to the heading Duplicating Objects though)

    Reply
    • Philip Treacy

      February 23, 2018 at 1:34 pm

      Thx Alex

      Reply
  11. Alan Cannon

    February 22, 2018 at 11:03 pm

    Why go to the extra step using the keyboard unless you just like using the keyboard. Using just the mouse you can drag the lower right corner of your selection down to accomplish the same thing. And it will also work to copy a vertical selection into adjacent columns. This will only work with text and formulae, not with charts or shapes.

    Reply
    • Philip Treacy

      February 23, 2018 at 7:06 pm

      Hi Alan,

      Yes you can use the mouse for this too, I’m just informing people of ways to do things.

      Actually depending on how your data is set up you can just double click the fill handle to fill down – no need to even drag.

      double click fill handle

      Regards

      Phil

      Reply
  12. Juan

    February 22, 2018 at 10:54 pm

    Thank you very much for sharing this great tip, Phil.
    I tried in the Spanish version of Excel and the shortcut is Ctrl+J.

    Reply
    • Philip Treacy

      February 23, 2018 at 1:35 pm

      Thanks Juan. What does CTRL+D do in Spanish?

      Reply
      • Juan

        March 7, 2018 at 5:05 am

        You are welcome, Phil. In Spanish, Ctrl+D is “Fill right from cell left”: copies the content and the format of the leftmost cell I think the shortcut in English is Ctrl+R. How weird that the shortcuts are different according to the language version!

        Reply
        • Philip Treacy

          March 7, 2018 at 9:48 pm

          Yes that is CTRL+D. Don’t know why it’s different in Spanish

          Reply
          • jim

            December 1, 2018 at 1:02 am

            “Derecha” is the Spanish for “Right”

          • Philip Treacy

            December 1, 2018 at 9:08 pm

            Thanks Jim

Leave a Reply Cancel reply

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

Current ye@r *

Leave this field empty

Sidebar

More results...

launch excel macros course excel vba course

Featured Content

  • 10 Common Excel Mistakes to Avoid
  • Top Excel Functions for Data Analysts
  • Secrets to Building Excel Dashboards in Less Than 15 Minutes
  • Pro Excel Formula Writing Tips
  • Hidden Excel Double-Click Shortcuts
  • Top 10 Intermediate Excel Functions
  • 5 Pro Excel Dashboard Design Tips
  • 5 Excel SUM Function Tricks
  • 239 Excel Keyboard Shortcuts

100 Excel Tips and Tricks eBook

Download Free Tips & Tricks

Subscribe to Our Newsletter

Receive weekly tutorials on Excel, Power Query, Power Pivot, Power BI and More.

We respect your email privacy

239 Excel Keyboard Shortcuts

Download Free PDF

mynda treacy microsoft mvpHi, I'm Mynda Treacy and I run MOTH with my husband, Phil. Through our blog, webinars, YouTube channel and courses we hope we can help you learn Excel, Power Pivot and DAX, Power Query, Power BI, and Excel Dashboards.

Blog Categories

  • Excel
  • Excel Charts
  • Excel Dashboard
  • Excel Formulas
  • Excel PivotTables
  • Excel Shortcuts
  • Excel VBA
  • General Tips
  • Online Training
  • Outlook
  • Power Apps
  • Power Automate
  • Power BI
  • Power Pivot
  • Power Query
microsoft mvp logo
trustpilot excellent rating
Secured by Sucuri Badge
MyOnlineTrainingHub on YouTube Mynda Treacy on Linked In Mynda Treacy on Instagram Mynda Treacy on Twitter Mynda Treacy on Pinterest MyOnlineTrainingHub on Facebook
 

Company

  • About My Online Training Hub
  • Disclosure Statement
  • Frequently Asked Questions
  • Guarantee
  • Privacy Policy
  • Terms & Conditions
  • Testimonials
  • Become an Affiliate

Support

  • Contact
  • Forum
  • Helpdesk – For Technical Issues

Copyright © 2023 · My Online Training Hub · All Rights Reserved. Microsoft and the Microsoft Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. Product names, logos, brands, and other trademarks featured or referred to within this website are the property of their respective trademark holders.