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

Пікірлер: 145

  • @suzsano
    @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!

  • @rajendraghimire2008
    @rajendraghimire20083 жыл бұрын

    Excellent, clear and comprehensive explanation! Thank you!

  • @mdswim2002
    @mdswim200223 күн бұрын

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

  • @adelaidemakaya4893
    @adelaidemakaya4893 Жыл бұрын

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

  • @marionroberts6825
    @marionroberts6825 Жыл бұрын

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

  • @ujjayantchakravorty1115
    @ujjayantchakravorty11153 жыл бұрын

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

  • @minamioppai8414
    @minamioppai84143 жыл бұрын

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

  • @sylviade604
    @sylviade6042 жыл бұрын

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

  • @superprettyhazel
    @superprettyhazel Жыл бұрын

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

  • @roni-lilshapka2529
    @roni-lilshapka25293 ай бұрын

    Thanks so much !! Well shown !

  • @jasmindagatan3008
    @jasmindagatan30082 жыл бұрын

    Thank you! Easy tutorial for beginners.

  • @paulphilippou656
    @paulphilippou6563 жыл бұрын

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

  • @shamsalbasri8048
    @shamsalbasri80482 жыл бұрын

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

  • @stjackso17
    @stjackso173 жыл бұрын

    Finally what I was looking for. Thanks!

  • @dleetrini
    @dleetrini2 жыл бұрын

    This was very well explained, thank you!

  • @ak-ux8pr
    @ak-ux8pr7 ай бұрын

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

  • @aburaihan5871
    @aburaihan5871Ай бұрын

    Great! Thank you.

  • @apaintingjourney6985
    @apaintingjourney69853 ай бұрын

    Thank you so much! Very helpful!

  • @ashutoshj785
    @ashutoshj7856 ай бұрын

    Thanks , this really helped

  • @christinew2510
    @christinew25102 жыл бұрын

    Great tutorial!!Thank you!

  • @TshepoModungwa
    @TshepoModungwa2 жыл бұрын

    This was quite helpful! Thank you

  • @ladunayooyetokun6205
    @ladunayooyetokun6205 Жыл бұрын

    So helpful, thank you

  • @brandon7920
    @brandon79202 жыл бұрын

    thank you man straightforward i like it !!

  • @ichbinnasrin
    @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!

  • @jusypolo6575
    @jusypolo65752 жыл бұрын

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

  • @pafarmgirl9519
    @pafarmgirl95195 ай бұрын

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

  • @LOL999999mm
    @LOL999999mm7 ай бұрын

    Thanks!! You made it so easy.

  • @juliennezhou4851
    @juliennezhou4851 Жыл бұрын

    Thank you! This is so helpful!

  • @judetubemoran6275
    @judetubemoran62755 ай бұрын

    Excellent guide, many thanks.

  • @jasonwilson556
    @jasonwilson556 Жыл бұрын

    Super helpful!!!

  • @chandiscooper669
    @chandiscooper669 Жыл бұрын

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

  • @Devagrace
    @Devagrace Жыл бұрын

    Thank you for a simple explanation :)

  • @goddessm.w9563
    @goddessm.w9563 Жыл бұрын

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

  • @SallyDov
    @SallyDov2 жыл бұрын

    Thank you so much for clear explanation and comprehensive.

  • @db19812009
    @db198120092 жыл бұрын

    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.

  • @marriettemapheto8910
    @marriettemapheto89102 жыл бұрын

    Very helpful, thank you very much.

  • @benkrauss5041
    @benkrauss50412 жыл бұрын

    You sir are a lifesaver! Much love

  • @BarryFurzer
    @BarryFurzer Жыл бұрын

    Awesome thank you

  • @muralikolluru9625
    @muralikolluru96257 ай бұрын

    Thanks.. it works

  • @QueenShri786
    @QueenShri7863 жыл бұрын

    Really helpful man!

  • @mangeshshete6649
    @mangeshshete6649 Жыл бұрын

    Thanks it's pretty Helpfull

  • @assistantregistrarkdu4844
    @assistantregistrarkdu4844 Жыл бұрын

    Thank you very much for your help

  • @coolstuffunboxings1127
    @coolstuffunboxings11273 жыл бұрын

    Excellent Video!!!

  • @albinachisanga4102
    @albinachisanga4102 Жыл бұрын

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

  • @yolandapendleton7088
    @yolandapendleton70883 ай бұрын

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

  • @_avi19_49
    @_avi19_492 жыл бұрын

    Thanks this was so helpful.

  • @Vishnu_Ramakrishnan
    @Vishnu_Ramakrishnan2 жыл бұрын

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

  • @jithuvdinesan92
    @jithuvdinesan922 жыл бұрын

    Thank you brother helps a lot :) keep it up

  • @mhamidul1
    @mhamidul12 жыл бұрын

    Great Video

  • @centuryplantmusic
    @centuryplantmusic3 жыл бұрын

    Thank you for the brevity. Nice video

  • @paulbates2912
    @paulbates2912 Жыл бұрын

    Thank you so much

  • @sofian-_-7
    @sofian-_-72 жыл бұрын

    Thank you, very useful

  • @zafarahmad341
    @zafarahmad341 Жыл бұрын

    Thank you so much for teaching us

  • @jdlt5941
    @jdlt59413 жыл бұрын

    Thank you for the help

  • @starrprince_Live
    @starrprince_Live9 ай бұрын

    Thank you.

  • @sallamsallam33
    @sallamsallam332 жыл бұрын

    That's very helpful, Thanks alot 🌹

  • @lulubrady6129
    @lulubrady61294 жыл бұрын

    Very well explained. Thank you!

  • @ProfessorAdamMorgan

    @ProfessorAdamMorgan

    4 жыл бұрын

    Glad it was helpful! Thanks for watching, Lulu!

  • @hiltonbarua6079
    @hiltonbarua60792 жыл бұрын

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

  • @chetanmorya4385
    @chetanmorya43853 жыл бұрын

    Excellent sir....Really helpful 👍

  • @sylvie1231
    @sylvie12319 ай бұрын

    Thanks 🙏🏼

  • @Asyncwav
    @Asyncwav2 жыл бұрын

    Thanks a lot Sir!

  • @carolfung4696
    @carolfung46963 ай бұрын

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

  • @joydipchowdhury4603
    @joydipchowdhury46033 жыл бұрын

    Thanks bro you are a life saver

  • @santoshkumarpattnaik4454
    @santoshkumarpattnaik44542 жыл бұрын

    Thank you Boss

  • @user-lf5qh8ik1e
    @user-lf5qh8ik1e8 ай бұрын

    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

  • @teedarlene4408
    @teedarlene44083 жыл бұрын

    thank you so much!

  • @user-zf9se2cv1v
    @user-zf9se2cv1v2 ай бұрын

    thank you G

  • @anshifmohamed6220
    @anshifmohamed62202 ай бұрын

    THANKYOU

  • @sharimsmusicvideos
    @sharimsmusicvideos Жыл бұрын

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

  • @jeniece1mad
    @jeniece1mad4 жыл бұрын

    Thank you for your help!

  • @ProfessorAdamMorgan

    @ProfessorAdamMorgan

    4 жыл бұрын

    You're welcome! Thanks for watching, Jeniece!

  • @robvillegas216
    @robvillegas21611 ай бұрын

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

  • @quilass7186
    @quilass7186 Жыл бұрын

    Thank you

  • @MiuArtStudioUK
    @MiuArtStudioUK2 жыл бұрын

    Thank you very much!

  • @jideakinola2398
    @jideakinola2398 Жыл бұрын

    Thank you very much. I😊

  • @EdgarX007
    @EdgarX0073 жыл бұрын

    Thanks so much

  • @jaiswansekaran6028
    @jaiswansekaran60283 жыл бұрын

    Thank u very much

  • @studychannel8045
    @studychannel80453 жыл бұрын

    VERY MUCH THANKS

  • @samuelraj7210
    @samuelraj72102 жыл бұрын

    Thanks a millon bro

  • @mohammedfahadsarangani9887
    @mohammedfahadsarangani98873 жыл бұрын

    Thanks...!

  • @thepeddler9226
    @thepeddler92263 жыл бұрын

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

  • @anirbanbose8559
    @anirbanbose8559 Жыл бұрын

    thanx bro

  • @just.click0777
    @just.click0777 Жыл бұрын

    Thanks

  • @californiabusinessadvisors9244
    @californiabusinessadvisors9244 Жыл бұрын

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

  • @vanshikabali7231
    @vanshikabali72313 жыл бұрын

    Awesome 👏

  • @ProfessorAdamMorgan

    @ProfessorAdamMorgan

    3 жыл бұрын

    Thanks 🤗

  • @vanderdossantos6676
    @vanderdossantos66763 жыл бұрын

    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.

  • @ChavraSuarez
    @ChavraSuarez Жыл бұрын

    Thnx

  • @nieco2528
    @nieco25283 жыл бұрын

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

  • @MRJOSIM-hf3og
    @MRJOSIM-hf3og Жыл бұрын

    thanks

  • @sagharzekri8531
    @sagharzekri85314 жыл бұрын

    this is what I was looking for . thankssss

  • @ProfessorAdamMorgan

    @ProfessorAdamMorgan

    4 жыл бұрын

    No problem, thanks for watching!

  • @moryamin5188
    @moryamin51882 жыл бұрын

    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?

  • @anthonyharmon8665
    @anthonyharmon86653 жыл бұрын

    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.

  • @debgent4350
    @debgent43503 ай бұрын

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

  • @noimejadia6460
    @noimejadia64603 жыл бұрын

    If i edited the data on the copied is the formula applied on the sheet will be lost?

  • @brentriggs1223
    @brentriggs12235 ай бұрын

    Will this copy drop down lists as well?

  • @bijaytanty8434
    @bijaytanty84344 ай бұрын

    👍🏻👍🏻🙏🏻

  • @bobwilson865
    @bobwilson8653 жыл бұрын

    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

  • @shrikantwalhe8493
    @shrikantwalhe84932 жыл бұрын

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

  • @mohammedfiezaan8652
    @mohammedfiezaan86522 жыл бұрын

    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

  • @ahmedennakach7103
    @ahmedennakach71032 жыл бұрын

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

  • @pavankumar-nr4mv
    @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?