Skip to content
new ogbongeblog logo
  • Advertise
  • Blog
  • Contact

How To Copy WorkSheet From Excel Workbook File To Another

  1. Home
  2. Blog
  3. how to
  4. How To Copy WorkSheet From Excel Workbook File To Another
March 3, 2014

Written by

jidetheblogger Avatar
jidetheblogger

Last Modified :

January 20, 2025

Sometimes, you might have an Excel worksheet you wish to include as a worksheet in another Excel file i.e workbook. You can get this done with ease using an Excel built-in feature instead of using “copy and paste”. Using “copy and Paste” can frustrate you and might even make you lose some formatting styles.

The trick am sharing with you in this tutorial will let you insert worksheets from other workbooks quickly without losing data and formatting styles. It simply involves the use of the “ Move or Copy ” command in the same instance of Excel.

As an example, I’m going to show you how I copied a worksheet in Excel 2003 from a “ source ” workbook i.e sales.xls to a “ target ” workbook i.e jideexcel.xls. Just follow me through the steps:

1. Open the workbooks you want to work with (source and the target workbook)
2. In the source workbook, click on the tab of the sheet you want to copy
3. Right click the selected worksheet, and click Move or Copy

Excel_move or copy

4. In Move or Copy dialog box, click the “ create a copy ” option and choose the target workbook from the “ To book ” dropdown. Excel will display only the open workbooks in this list.

microsoft excel
excel

5. Click OK and Excel will move or copy the sheet to the target workbook.

That’s all.

I hope it works for you.

You can get a free Beginners guide to working with spreadsheets in excel and DIAGRAMMATIC presentations on how to use Excel from my 20 Free Ebooks here .

Please Share :
excel tips

Like What You Read?

Sign Up to get similar articles delivered to your email inbox.

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

One response to “How To Copy WorkSheet From Excel Workbook File To Another”

  1. Omotunde Avatar
    Omotunde
    March 3, 2014

    Thanks for the info Jide especially for the link to the 20 free ebooks. God bless you bro.

    Loading…
    Reply

WANT TO ADVERTISE?

Chat on WhatsApp

RELATED POSTS

  • Convert XLS : Free Software That Converts XLSB File To XLS
  • How I Convert Microsoft Excel xlsx Files To Xls Format of Excel 2003 at Zamzar.comzamzar online converter
  • The Top Three Benefits of Using PDF to Word Convertorpdf to word converter

FEATURED


  • How to Pay Chinese Suppliers in RMB (Alipay & WeChat Pay) or Swap Naira, Kenyan Shillings, Ghana Cedis & USDT in Minutes

    How to Pay Chinese Suppliers in RMB (Alipay & WeChat Pay) or Swap Naira, Kenyan Shillings, Ghana Cedis & USDT in Minutes

JOIN AI WEB DESIGN GROUP


  • AI Website Design Training Whatsapp Group by Jidetheblogger

    AI Website Design Training Whatsapp Group by Jidetheblogger

RANDOM POSTS


    I Got One Free Month of Meta Verified After I Tried to Cancel My Subscription


    How To Make Money On Bamboo App: 5 Proven Ways


    How To Use Vibe Coding To Make Money


    How I Earn $100 Per Referral from Affiliate Marketing


    Bluetooth Printer That Connects To Phone


    Can I Use OPay Card for Facebook Ads?


    Why I Moved My Websites From Namecheap To Interserver.net


    How I Earn $50 Per Sale


MORE RANDOM POSTS
← Google Scrapper Report Form For Reporting Copycats
Download Free pdf Ebooks Weekly →

Join 25,000+ subscribers

Receive our latest blog posts in your inbox.

Search

Social

Facebook

Instagram

Twitter

new ogbongeblog logo

Copyright © 2026 | About | Advertise | Featured | Sitemap | Privacy Policy | Powered by WordPress

Your cart (items: 0)

Products in cart

Product
Details
Total
Subtotal ₦0.00
Shipping and discounts calculated at checkout.
View cart
Go to checkout

Your shopping cart is empty

Return to shop

Notifications

%d

    LIKE My Fan Page

    Privacy Policy | Copyright © 2012,OgbongeBlog.All Rights Reserved. Powered by Blogger .
    Create a Mobile Site
    View Site in Mobile | Classic
    Share by: