Copying or Moving a Sheet in Microsoft Excel 2010

 

In this article, we will learn how we can copy or move a sheet in Microsoft Excel 2010.

We know that a single workbook contains many worksheets. Worksheets can be added, deleted, and managed in the tabs at the bottom.

When we need a worksheet data in another workbook, usually we copy and paste the entire worksheet and reformat and set the data again. But if we move the worksheet data to another workbook, we don’t need to reformat the data again.

Let’s take an example to understand how we can copy and move a sheet.

We have a worksheet, in the range A1: C20. Column A contains Name, column B contains Score, and column C contains percentage.
 
img1
 
How to copy the data from one sheet to another sheet in a workbook?

Follow below given steps:-

  • Select the sheet which you want to move or copy in another sheet.
  • Select the all data press the key Ctrl+C on your keyboard.

 
img2
 

  • Go to sheet2 and press the key Ctrl+V.

 
img3
 

  • You will find out the column width and row heights get change.
  • We will need to reformat it accordingly.

To move the data from one sheet to another sheet in a workbook, follow below given steps:-

  • Select the sheet which you want to move or copy in another sheet.
  • Go to sheet tab and right click with the mouse.
  • A pop up will appear.
  • Select move or copy option.

 
img4
 

  • Move or Copy dialog box will appear.

 
img5
 

  • Check the option of create a copy.
  • Click on OK.
  • Data will get moved or copied in another sheet with the name Sheet1 (2).

 
img6
 
This is the way we can copy or move a sheet in Microsoft Excel.
 
 



Leave a Reply

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

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>