Excel shortcuts

Duplicate sheet in excel shortcut: How to quickly make copies of sheets in Excel

If you're anything like me, you're always looking for ways to work more efficiently in Excel. One of the things that can really help speed up your work is to have keyboard shortcuts for the things you do most often. That's why today I want to show you how to create a keyboard shortcut to quickly duplicate sheets in Excel.

The first thing you need to do is open up the Excel workbook that you want to create the shortcut in. Then, go to the File tab and click on Options. In the Excel Options dialog box that appears, select the Customize Ribbon option from the left-hand side. On the right-hand side, under the Main Tabs section, check the box next to Developer. Click OK to close the dialog box.

Now that the Developer tab is visible, go to that tab and click on the Macros button. In the Macros dialog box that appears, click on the New button. In the Create Macro dialog box that appears, give your macro a name (I like to use the name of the thing I'm creating a shortcut for, so in this case I would name it DuplicateSheet) and then click on the Keyboard button.

In the Assign Macro dialog box that appears, under the Macro name drop-down, select the macro you just created. Then, under the Store macro in drop-down, make sure the Personal Macro Workbook option is selected. Finally, under the Shortcut key field, type in the keyboard shortcut you want to use for the macro. I like to use Ctrl+Shift+D for this shortcut, but you can use whatever shortcut you want. Once you've done that, click Assign and then Close to close the dialog boxes.

Now that you've created the shortcut, you can use it by simply selecting the sheet you want to duplicate and then pressing the shortcut key you assigned to the macro. Excel will create a copy of the sheet and place it after the original sheet. Pretty nifty, huh?

I hope you found this tip helpful. If you have any questions, feel free to post them in the comments section below. And if you know of any other helpful Excel shortcuts, be sure to share them with us!

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.