Copy And Paste Excel Sheets Faster With This Shortcut!

Подписаться 568 тыс.

Просмотров 362 тыс.

50% 1

Are you guilty of this Excel Bad Habit? There's an easier way to copy Excel worksheets! Our quick tutorial will show you how.
If you're looking for more shortcuts, we're giving away our Excel shortcut guide with over 200 shortcuts. Download it here: www.excelcampus.com/shortcuts/
And check out ‪@ExcelCampus‬ for more Microsoft Excel tutoring!

Опубликовано:

12 дек 2022

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 53

@ePCAYT Год назад

I didn't realize this (common copy) shortcut works here also. Thank you. However, it is much easier to hold the Ctrl key before dragging.

@JessicaJang77 10 месяцев назад

like👍 select + drag.. + CTRL Thanks always😊

@rukhsana_rukh 11 месяцев назад

I've seen lot of tutorials on RU-vid.. Your videos are easy to understand.. You explain all the steps including using the mouse

@ExcelCampus 11 месяцев назад

Thanks so much! I appreciate the nice feedback and your support. 🙂

@NikleshKumar-yx1wf 11 дней назад

So helpful ❤❤❤❤❤

@innawoodsman 6 месяцев назад

I was literally just creating my monthly budget workbook for next year and wishing there was an easier way to copy the sheet for each month than what I was doing. Thanks for this

@ExcelCampus 6 месяцев назад

Glad it was helpful! 😀

@DuncanRandall-rs8pt 8 месяцев назад

Thanks for this, great video - I found an add on that lets you unhide/delete hidden sheets, called Sheets Manager. Thanks again!!

@ExcelCampus 7 месяцев назад

You're welcome, Duncan! 😀

@corinnastringerofficial Год назад

Thank you for this, saved me a lot of time 👍🏼

@ExcelCampus Год назад

You're welcome, Corinna! :)

@martybadboy Год назад

I'm not so much impressed with the time savings but the workflow is way better with this method.

@zbmalikmalik5350 6 месяцев назад

Very helpful video Thanks

@ExcelCampus 6 месяцев назад

Happy to help! 😀

@nurserytoys Год назад

#Excellent Sir

@sinistergroupon Год назад

How many sheets do you need to be copying a year to save an hour?

@lawalayobamivictor2214 2 месяца назад

Thank you for this.

@ExcelCampus 2 месяца назад

My pleasure! 😀

@salehalavy Год назад

Hey I wanna make lookup where if the logic input is between a threshold for example from 1000 to 2000 it gives it number 75 and go on

@rampatil4021 2 месяца назад

Awesome ❤

@ExcelCampus 2 месяца назад

🙌

@cjjr85 Год назад

Nice

@mohanmadhava3078 Год назад

Yahhhh😍😍😍😍

@maicomt77 2 месяца назад

Thank you

@ExcelCampus 2 месяца назад

Welcome! 😀

@mohsin1877 9 месяцев назад

Thanks a lot brooo🎉❤❤❤

@ExcelCampus 9 месяцев назад

Welcome, @mohsin1877 😊

@HelloErth Год назад

Alt E M is even faster..

@matteo.gerardo 5 месяцев назад

Thank you!!!

@AppleTreeResources-gr5to8 3 месяца назад

Thank you!!!

@ExcelCampus 3 месяца назад

Welcome! 😀

@republikadugave420 Год назад

Yes but can you move it to a different file?

@ilhamzaidan1944 6 месяцев назад

Thankyou

@ExcelCampus 5 месяцев назад

You’re welcome 😊

@justaregularguy7982 Год назад

Or you can just use the shortcut Alt+E+M+Tab+ Enter

@DeanGadberryYT 10 месяцев назад

This is the best reply. You would receive all of my ad-revenue if you put this information in a blog post. Thank You sir!

@brendamg7298 11 месяцев назад

👏🏻👏🏻👏🏻

@sunnyjain2 7 месяцев назад

How to select multiple sheets

@ExcelCampus 5 месяцев назад

Great question! You can either hold the Ctrl key and click individual sheets. Or you can hold the Shift key to select all sheets from the currently selected sheet to the one you click on. I used Shift in the video.

@sruthy_usha 6 месяцев назад

How to add that sheet 1 &2 🙄please help

@emindsaleh1066 Год назад

What about if you want to copy to new book?🙏

@ExcelCampus 5 месяцев назад

Great question! I don't believe there is a direct shortcut for a new workbook. You can drag and drop sheets to existing workbooks. We have a video on that. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-s3APHCHaBKo.html For a new workbook, you could press Ctrl+N, then drag the sheet tab to that workbook. But it might be faster to just go through the sheet tab menu.

@matteo.gerardo 5 месяцев назад

is there a keyboard shortcut for this?

@ExcelCampus 5 месяцев назад

I don't believe there is a direct shortcut. You can open the Move or Copy window through a series of key strokes, but I don't know that it will be any faster. You can open the sheet tab's right click menu with the Menu key. Only some keyboards have a Menu key. Here is a post that covers it. www.excelcampus.com/keyboard-shortcuts/excel-keyboard-shortcuts-convert-text-to-numbers-ignore-errors/ You can press F6 to set focus to the sheet tab, then press the Menu key, then M to open the Move or Copy window. You can also add the Move or Copy button the Quick Access Toolbar to create a quicker shortcut for it. I hope that helps.

@ImTheFatDad Год назад

Can you do it across workbooks too?

@ExcelCampus 5 месяцев назад

Yes! Here is a tutorial that explains it. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-s3APHCHaBKo.html I hope that helps. 🙂

@jeraldthalaiva85 Год назад

What is shortcut key for right click pls tell me sir

@jeraldthalaiva85 7 месяцев назад

Sir, sheet 1 ur clicking on mouse I am asked without mouse how u right click sir??

@ExcelCampus 5 месяцев назад

Typically you can do that with the Menu key. Only some keyboards have a Menu key. Here is a post that covers it. www.excelcampus.com/keyboard-shortcuts/excel-keyboard-shortcuts-convert-text-to-numbers-ignore-errors/ You can press F6 to set focus to the sheet tab, then press the Menu key, then M to open the Move or Copy window. You can also add the Move or Copy button the Quick Access Toolbar to create a quicker shortcut for it. I hope that helps. Thanks again and have a nice day! 🙂

@jeraldthalaiva85 7 месяцев назад

What is shortcut keys for right click tell me sir in this sheet

@ExcelCampus 7 месяцев назад

Great question, Jerald! To open the right-click menu, use Shift+F10 OR Menu Key in Windows. Use Fn+Shift+F10 for Mac.

@jeraldthalaiva85 7 месяцев назад

@@ExcelCampus sir, I am asking excel sheet name right click shortcut... Shift F10 is main shortcut but excel sheet shortcut?

@ExcelCampus 7 месяцев назад

Rename current worksheet - Alt,O,H,R