Excel - Quickly Make Multiple Copies Of A Sheet In Excel - Episode 1981
Microsoft Excel Tutorial - technique to quickly copy worksheets in Excel.
Welcome to another episode of the MrExcel podcast! In today's episode, we will be discussing a fast and efficient way to copy worksheets in Excel. If you're enjoying the tips in this series, make sure to subscribe to the "MrExcel XL" playlist, where I will be podcasting the entire book.
Have you ever found yourself in a situation where you need to make a copy of a worksheet for the next month or quarter? In the past, I used to insert a new worksheet, copy all the cells, and then try to get all the settings right. But then, a colleague from my previous job showed me a much faster way - right-click on the tab and choose "Move or Copy". This was a game-changer for me, but little did I know, there was an even faster way.
The real time-saver comes from using the CTRL key and dragging the worksheet to the right. This will create a copy of the worksheet with just a few clicks. And the best part? You can do this for multiple worksheets at once. Just select the worksheets you want to copy, hold down the CTRL key, and drag the first worksheet to the right. This will create copies of all the selected worksheets in one go.
Now, I have a little rant about a feature that I've been wanting in Excel for years. We all know that if you type "January" in a cell and drag the fill handle, Excel will automatically fill in the following months. So why can't we have the same feature when copying worksheets? I've even submitted this idea to the Excel team 10 years ago, but it still hasn't been implemented. That's why I've created a new idea on Excel.UserVoice.com - "Fill Handle For Worksheet Copy". If you think this would be a great addition to Excel, please go and vote for it using the short link mrx.cl/sheetautofill.
But wait, there's more! In a previous podcast episode, I shared a VBA macro that can automatically rename worksheets based on a custom list. So not only can we have the months automatically filled in, but we can also have the worksheets renamed with just a few lines of code. If you're not familiar with VBA, don't worry, I've included the link to that episode in the description below. And who knows, maybe someone from the Excel team will see this and implement it in a future update.
And finally, if you're enjoying these tips and want to save even more time, you can purchase the "MrExcel XL" book for just $25. This book contains over 40 Excel tips, along with cartoons, cocktails, tweets, and jokes. Just click on the "i" in the top-right corner to get your copy. And don't forget to tune in every day in August for a new tip from the book.
To recap, in today's episode, we learned how to quickly copy worksheets in Excel using the right-click method and the CTRL-drag method. We also discussed my user voice idea for a fill handle feature for worksheet copy and the VBA macro that can automatically rename worksheets. Thank you for watching, and I'll see you in the next episode of the MrExcel podcast!
Buy Bill Jelen's latest Excel book:
You can help my channel by clicking Like or commenting below:
Table of Contents:
(00:00) Fast Worksheet Copy tip for Excel
(00:30) Move or Copy Worksheet command
(01:04) Faster way Ctrl+Drag Sheet Tab
(01:46) Request for automatic sheet naming feature in Excel
(02:49) Alternative method using VBA macro
(03:53) Clicking Like really helps the algorithm
This video answers these common search terms:
how to make copies of worksheets in excel
make multiple copies of a sheet in excel
video to make copies of excel worksheet
how to make multiple copies of sheet in excel
how to copy a formatted excel sheet
how to copy excel sheet with formatting
copy a sheet in excel
copy a worksheet in excel
how copy an excel sheet
how to copy a sheet in excel with formulas
how to copy an excel worksheet with formulas
how to copy a sheet for another excel workbook
Ctrl+Drag sheet tabs to make a copy. This episode also covers:
Right-click tab and choose Move or Copy
Ctrl+Drag worksheet for Mar through June
Select Jan:June and Ctrl+Drag January to make 6 copies
Vote for my uservoice idea
Using an Immediate Macro to rename sheets
Podcast Episode 1497 had FillHandleSheets macro:
There is some bonus VBA here to rename 12 sheets with month names.
Join the MrExcel Message Board discussion about this video at
Watch video Excel - Quickly Make Multiple Copies Of A Sheet In Excel - Episode 1981 online without registration, duration 04 minute 40 second in high hd quality. This video was added by user MrExcel.com 08 August 2016, don't forget to share it with your friends and acquaintances, it has been viewed on our site 3 thousand once and liked it 6 people.