Perhaps you have worksheet data that you'd like to copy from one worksheet to another blank worksheet. An easy way to do so is to click the worksheet tab of the sheet that you want to copy, hold down CTRL, and then drag the selected sheet along the row of sheet tabs. As you drag, you'll see a small worksheet symbol with a plus (+) sign on it, indicating that you are copying a worksheet. A small downward pointing arrow will follow along.
When you get to the location where you want to add the copied worksheet, indicated by the downward pointing arrow, release the mouse button, and then release the CTRL key.
There's another way to copy a worksheet: You can right-click the worksheet tab, and then click Move or Copy on the shortcut menu. There's one more step to this method, which you'll see in the practice at the end of the lesson.
Or you might need to move a worksheet to change the order in which you've organized a set of worksheets, or to change the order of a newly inserted worksheet.
To move a worksheet, you can drag the selected sheet along the row of sheet tabs. Click the tab of the sheet you want to move. When you hold down the mouse button, you'll see a small worksheet symbol (this time without a plus (+) sign). Drag the sheet tab to a new position, and a small downward pointing arrow will follow along. When the arrow reaches the position where you want to place the sheet, release the mouse button.
Or you can right-click the tab on the sheet that you want to move, and then click Move or Copy on the shortcut menu.
Note Take care when you move or copy sheets if you have formulas in the worksheets. Calculations or charts based on worksheet data might become inaccurate if you move the worksheets. If you insert a worksheet between sheets that are referred to by a 3-D formula reference, data on that worksheet might be included in the calculation.