Excel 2016 - Move & Copy Sheets - How to Transfer Data Between Another Workbook - Workbooks Sheet MS

This Microsoft Excel 2016 tutorial shows you how to copy and move worksheets between files in MS Office 365. I show you how to move a document to another file, and how to paste your information into a different workbook.
Here is a full list of tutorial videos available on my channel:
Windows 10:
Perform Basic Mouse Operations
Create Folders
Explore the Windows 10 Desktop, Taskbar, and Start Menu
Select Multiple Files and Folders
Download a File From a Website
Use File Explorer to Access OneDrive and Upload Student Data Files
Capture an Image of the Entire Screen
Explore the Control Panel and the Settings App
Personalize the Desktop
Modify Screen Brightness and Resolution
Explore the Control Panel and the Settings App
Personalize the Desktop
Adjust the Sound
Plan the Organization of Files and Folders
Run an App
Word 2016:
Create a New Document and Insert Text
Insert and Format Graphics
Insert and Modify Text Boxes
Create a Table
Format a Table
Present a Word Document Online
Create a Research Paper in MLA Format
Insert Footnotes in a Research Paper
Create Citations and a Bibliography
Save a Document
Correct Errors as You Type
How to Format a Document in APA Format
Convert Word Document to a PDF File
Microsoft Office Specialist Certification Exam Practice Study Guide
APA Format from Default Formatting
Table of Contents Tutorial
Format Paragraphs
Create a Custom Word Template
Preview and Print a Document
Change Document and Paragraph Layout
Use AutoComplete and AutoCorrect
Correct and Reorganize Text
Header and Footer Tutorial
Page Numbers Tutorial
Captions in Word
Review Document Headings in the Navigation Pane
Reorganize Document Text Using the Navigation Pane
Collapse and Expand Body Text in a Document
Use Continuous Section Breaks for Page Layout
Insert Page Numbers Starting from a Specific Page
Format Text
Undo and redo Commands or Actions
Modify a Style
Excel 2016:
Create, Save, and Navigate an Excel Workbook
Enter Data in a Worksheet
How do you Export Access to Excel and Apply Conditional Formatting
Use Flash Fill, SUM, Average, Median, and MAX Functions and Formulas
Move Data and Rotate Text
Graph Data with a Pie Chart
Format a Pie Chart
MOS Prep - Basic Certification Exam Practice Study Guide
Change Fonts, Font Style, and Font Color
The NOW Function
Export Excel Spreadsheet to Access Table
The VLookup Function
The MIN or MINIMUM Function
Histogram Charts
Use the Sum Button to Sum a Range of Cells
Enter Formulas Using the Keyboard
Format Cells with Merge & Center, Cell Styles, and Themes
Chart Data to Create a Column Chart & Insert Sparklines
Select Cells and Ranges
Use CountIF and IF Functions and Apply Conditional Formatting
Use Date &Time Functions and Freeze Panes
Use Goal Seek to Perform What-if Analysis
Add Fill Colors and a Background Image
Insert Functions from the Formula Library
Use the PMT Function to Calculate a Loan Payment
Describe the Excel Worksheet
Enter Formulas Using Point Mode
Access 2016:
Identify Good Database Design
Create a Table and Define Fields in a Blank Desktop Database
The Primary Key
Import Excel Spreadsheet into Access
Create a Table in Design View
Modify the Structure of a Table
Create a Subform
MOS Prep - Basic Certification Exam Practice Study Guide
Add Existing Fields to a Form
Create a Query, Form, and Report
How To Use the Property Sheet
Open and Save an Existing Database
Create Table Relationships
Learn Basic Database Concepts and Terms
Create and Use a Form to Add and Delete Records
Learn the Guidelines for Designing Databases and Setting Field Properties
Find, Modify, and Delete Records in a Table
Create a Form Using the Form Wizard
PowerPoint 2016:
Create a New Presentation
Edit a Presentation in Normal View
Add Pictures to a Presentation
Format Numbered and Bulleted Lists
Customize Slide Backgrounds and Themes
Animate a Slide Show
Apply a Theme Used in Another Presentation
Search for and Download an Online Theme
Microsoft Office Specialist Exam Certification
Print and View a Presentation
Lighten Background Images in Microsoft Office
Edit an Existing Presentation
Insert Online Pictures
Create a Title Slide and Slides With Lists
Select and Change a Document Theme and Variant
Insert and Format Pictures
Insert Shapes
Insert a Video
Outlook 2016
Basic Tutorial
Office 2016:
Identify the Components of the Microsoft Office Ribbon
Computer Fundamentals:
Computer Case Types - Dell Inspiron AMD 3656
Printer Ports and Types
The Boot Up Process
How to Get Your Computer Questions Answered
Undo Your Mistakes on Windows 10 or Apple Mac
Routers vs. Modems
What is the Cloud? Storage as a Service
Types of Internet Services on Google Android or Apple iPhone
Browsing the Web
Why Use the Cloud?
Microsoft OneDrive - Creating Uploading Downloading and Syncing
Explain the Importance of File Management
Troubleshoot Common Computer Problems
Microsoft Publisher 2016 Full Playlist

[@suzsano]

I literally looked through several videos and was honestly getting really frustrated, and I found Professor Adam Morgan, and it made it extremely easy! Thank you very much!

[@mdswim2002]

Just wanted to let you know that this explanation was thorough and clearly presented.

[@user-lf5qh8ik1e]

I tried to do this with multiple sheet (Select one sheet, hold shift, click the last sheet) and followed the same method, works fine. Thanx

[@pafarmgirl9519]

Thank you. This is very clear and concise. Great for me, I’m teaching myself Excel.

[@xuscbs]

Excellent, clear and comprehensive explanation! Thank you!

[@ProfessorAdamMorgan]

Glad it was helpful! Thank you for watching!

[@carolfung4696]

I just did my homework in a wrong file, you are definately a lifesaver!!!!🤝

[@marionroberts6825]

Adam, You made it seem so easy. My task is done. Thanks so much!!!!!

[@charleskeyessr4288]

Great... just what I needed for all my postcards....

[@db19812009]

Thank you for this!!! It helped a lot. Recently married and trying to merge finances. This help merge our separate excel things onto one document.

[@ak-ux8pr]

The way of teaching is easy and understandable. Thanks and regards

[@ichbinnasrin]

YES THANK YOU SO MUCH. I NEEDED THIS SO BAD AT WORK TODAY AND GOOGLING THE ANSWER SUCKED BUT THIS WAS SO STRAIGHT FORWARD!

[@adelaidemakaya4893]

Thank you so much for such a straight forward explanation , and straight to the point.

[@minamioppai8414]

Sir, you are a lifesaver. Thank you so much for this! 🙏🙏

[@RengiEbon]

Thank you Sir. This is extremely helpful

[@robvillegas216]

You're Chingon (Bad Ass) Professor. You saved me a lot of time. Awesome method

[@albinachisanga4102]

Wow....thank you so much Adam. You've helped me. As I Speak I'm in the office doing it.

[@californiabusinessadvisors9244]

Thanks, very helpful. I got my answer in 5 seconds or less.

[@Vishnu_Ramakrishnan]

Thanks bro i was searching that how to do it , in very simple way you shown it

[@SallyDov]

Thank you so much for clear explanation and comprehensive.

[@ujjayantchakravorty1115]

This is great, I needed to copy sheets and you gave me the answer after watching 5 other videos!

[@lulubrady6129]

Very well explained. Thank you!

[@ProfessorAdamMorgan]

Glad it was helpful! Thanks for watching, Lulu!

[@paulphilippou656]

Perfect! Thank you from Bangkok, Thailand. "SUBSCRIBED"

[@benkrauss5041]

You sir are a lifesaver! Much love

[@sharimsmusicvideos]

thanks this helped me transfer my files ...God Bless

[@roni-lilshapka2529]

Thanks so much !! Well shown !

[@yolandapendleton7088]

THANK YOUUUUUU SOOOooo Much!!! You are a Lifesavers!❤

[@superprettyhazel]

Straight to the point! Can't thank you enough! You just got yourself a new subscriber 😎😎

[@sylviade604]

Excellent! Straight to the point, very clear! Mthnx following

[@jasmindagatan3008]

Thank you! Easy tutorial for beginners.

[@judetubemoran6275]

Excellent guide, many thanks.

[@LOL999999mm]

Thanks!! You made it so easy.

[@zafarahmad341]

Thank you so much for teaching us

[@nieco2528]

THANK GOD FOR YOU!!! 🙌🏾🙌🏾🙌🏾

[@brandon7920]

thank you man straightforward i like it !!

[@Devagrace]

Thank you for a simple explanation :)

[@stjackso17]

Finally what I was looking for. Thanks!

[@assistantregistrarkdu4844]

Thank you very much for your help

[@ashutoshj785]

Thanks , this really helped

[@aburaihan5871]

Great! Thank you.

[@bobcharles9009]

tried it, and its only showing me the source workbook, and sheets within the source workbook. Excel 2013 win1064bit pro. yet had both workbooks open, at left tax returns and at right PC SE costs. Another site says click = in a cell then go to the source and select cells and hit enter, I do that and nothing happens, yet one is supposed to be taken back to the destination.

[@shamsalbasri8048]

Thank you so much for this video!! You saved me lots of time!!!

[@hiltonbarua6079]

Nice,Easy,Time Saving technique . Thank You So much >

[@sagharzekri8531]

this is what I was looking for . thankssss

[@ProfessorAdamMorgan]

No problem, thanks for watching!

[@debgent4350]

when you moved/copied the worksheet to a different workbook, did the formulas carry over as well?

[@ArvaBlissful]

Hello , I am trying it but on my system, excel don't show show name of other open excel to move or copy existing tab. how to fix this issue. On my other laptop I am not getting this issue. Can you guide me how to fix this issue

[@qistinaraidah6705]

hello, prof. I try to duplicate my sheet but it wont appear. How do I fix this?

[@juliennezhou4851]

Thank you! This is so helpful!

[@goddessm.w9563]

This video just helped me so much!!!!! Thank you❤

[@user-dg4ei5pv4r]

My excel worksheets aren't syncing with one another.. they are exported from Xero, not sure how to make it work?

[@chandiscooper669]

wow thanks so much i really needed this kepp up the great work !

[@vanderdossantos6676]

Adam, thank you so much for this tutorial. It was very helpful. I am struggling to copy a set of data from one sheet to another. When I select (Ctrl A)+ (Ctrl C) and go to the sheet I want to paste using (Ctrl V) it is giving me an error. Can you please tell me how to do it? Thank you.

[@marriettemapheto8910]

Very helpful, thank you very much.

[@sbk6052]

Thank you ❤

[@sudarshanjoshi3072]

Hi sir. In my excel its not showing the list of workbook in which i want to copy. Plz help

[@mangeshshete6649]

Thanks it's pretty Helpfull

[@joydipchowdhury4603]

Thanks bro you are a life saver

[@jeniece1mad]

Thank you for your help!

[@ProfessorAdamMorgan]

You're welcome! Thanks for watching, Jeniece!

[@jasonwilson556]

Super helpful!!!

[@paulbates2912]

Thank you so much

[@emilyparker4246]

Hi Adam. I followed the steps to move, did not click create a copy and my sheet isn’t in its new location either. Undo didn’t work. Any idea where my file is hiding?

[@BarryFurzer]

Awesome thank you

[@_avi19_49]

Thanks this was so helpful.

[@ladunayooyetokun6205]

So helpful, thank you

[@muralikolluru9625]

Thanks.. it works

[@TshepoModungwa]

This was quite helpful! Thank you

[@dleetrini]

This was very well explained, thank you!

[@sallamsallam33]

That's very helpful, Thanks alot 🌹

[@starrprince_Live]

Thank you.

[@mohammedfiezaan8652]

How do I add a excel sheet of another excel sheet into a existing sheet? Like I want excel sheet name apples into excel file banana.xls not click and have a new sheet

[@jusypolo6575]

This was very helpful. Thank you very much! :)

[@ahmedennakach7103]

I WANT TO DO THE SAME, but my other workbook doesn't figure n the list, even if it is open ,please help

[@centuryplantmusic]

Thank you for the brevity. Nice video

[@christinew2510]

Great tutorial!!Thank you!

[@pavankumar-nr4mv]

I have one more doubt if I edit or change the data in original sheet then it should update in copied sheet, can anyone help on this please?

[@tsegayebekele3600]

move to copy does not work for me for the case of create copy option is checked

[@MiuArtStudioUK]

Thank you very much!

[@jideakinola2398]

Thank you very much. I😊

[@Nick03-HY3NA]

Hi i have a problem while moving or copying the worksheets some of it i think moved somewhere else and now i cant find it 😢 can anyone please help or give me an idea

[@chetanmorya4385]

Excellent sir....Really helpful 👍

[@bobwilson865]

OK I'm sure this is simple...BUT...I've been using Microsoft 365 Family for a couple of years now. Excel user for over 25 years. Usually able to figure out "user error" myself, this time I'm stumped. I have a family bill sheet in excel I have used for over 12 years. I recently added some features to track expense categories. Copied it to another worksheet as a version 2 to make additional changes. I have now finished version 2 to its final state. But when I went to make a copy for the next month, right click, and options Insert, Delete Rename, Move or Copy, Tab Color, Hide, Unhide are not available to choose from, the only choices are, View Code, Protect Sheet or Select all Sheets. I am missing something simple, and after many wasted hours spent trying to figure it out, I need your expert advice. PLEASE HELP. Bob

[@JJCoop231]

What if you right click on the tab and it doesn’t give you an option “move or copy”

[@wandamgidi1425]

Thank you Man, you the best🫡

[@mhamidul1]

Great Video

[@quilass7186]

Thank you

[@coolstuffunboxings1127]

Excellent Video!!!

[@thepeddler9226]

I thought you were going to do multiple tabs for May/June. That would be a good add-on to this video. TFS, Nicole

[@jdlt5941]

Thank you for the help

[@moryamin5188]

Thanks Adam, it is a great video, I have a question for you , i have 2 workbooks open at the same time side by side . I want to change data in one of them and want to see same changes in 2nd workbook, How should i do?

[@user-zf9se2cv1v]

thank you G

[@jithuvdinesan92]

Thank you brother helps a lot :) keep it up

[@santoshkumarpattnaik4454]

Thank you Boss

[@shrikantwalhe8493]

Sir.. thank you.. i have another problem... how to export data (field) from one excel to another excel files??

[@studychannel8045]

VERY MUCH THANKS

[@teedarlene4408]

thank you so much!

[@brentriggs1223]

Will this copy drop down lists as well?

[@just.click0777]

Thanks

[@nishthagupta1357]

I don't have the move or copy option

[@anthonyharmon8665]

GM Mr. Morgan. I was wondering how I might take data listed on one spreadsheet and refer to it and use sum functions, etc for that data on another sheet. Please assist.

[@QueenShri786]

Really helpful man!

[@samuelraj7210]

Thanks a millon bro