How do I quickly duplicate a sheet in Excel? - Excel Tips and Tricks - video Dailymotion

ExcelTips247

Learn how to quickly duplicate a sheet in Excel. I will also show you how to duplicate a sheet in Excel using the keyboard, and how do you duplicate a sheet in Excel on a Mac. Is will be a simple how do I copy and paste Excel so it is exactly the same answer.  Finally, you can answer the question of can you duplicate an entire Excel sheet, and how do I duplicate a sheet in Excel multiple times shortcut?   Hold down the Ctrl key on your keyboard. Click and drag the sheet tab that you want to duplicate to the right or left. When you release the mouse button, this will create an exact copy of the sheet.   Here are the steps outlined in the video.   Copy Single Sheet  1) Click and hold left mouse button on the sheet.  2) Drag the mouse while holding the left mouse button.  3) Press Ctrl.  4) Release left mouse button.  5) Then release Ctrl   Copy Multiple Sheets  1) Hold Ctrl key.  2) Select multiple sheets (left mouse button).  3) Let go Ctrl key  4) Click and hold left mouse button on any of the selected sheet.  5) Drag the mouse while holding the left mouse button.  6) Press Ctrl  7) Release left mouse button.  8) Then release Ctrl    How do I quickly duplicate a sheet in Excel?,How do you duplicate a sheet in Excel using the keyboard?,How do you duplicate a sheet in Excel on a Mac?,How do I copy and paste Excel so it is exactly the same?,Can you duplicate an entire Excel sheet?,How do I duplicate a sheet in Excel multiple times shortcut?,

Transcript

00:00If you have to duplicate your worksheet, do not use this technique. You're going to have to click

00:03your mouse click a billion times before you get your duplicate worksheet. Let me show you another

00:06way which is more efficient. First thing you have to do is to select the sheet that you want to

00:11duplicate. Then you're going to hold and click your left mouse button here and then press ctrl

00:15on your keyboard and the icon should look like that with the sheet and a plus in it. Now select

00:20the location where you insert the duplicate sheet and let go of left mouse button like this and then

00:24let go of your control and that's how you duplicate the express sheet like this. Let me show you how

00:29you can do on a multiple sheet. First you're going to select the very first sheet you want to copy

00:34then hold ctrl and left mouse button on multiple sheet like this. Next let go of your control key

00:39on your keyboard. Now left mouse click and drag. The icon should look like that and now press your

00:47ctrl key and locate wherever you want to insert your new spreadsheet or duplicate sheet and let

00:52go of your left mouse button followed by the ctrl key.

How do I quickly duplicate a sheet in Excel? - Excel Tips and Tricks

Category

Transcript

Be the first to comment

Recommended