You can easily copy an entire worksheet in Excel, including all of its data and formatting by using the Move or Copy Sheet command from the menu. Excel provides a sequential number after the worksheet name to allow you to distinguish between the new sheet and the original sheet. For example, if you copied a sheet named June Sales, the new copied sheet would be named June Sales (2). You can copy a worksheet to any workbook that is open, to the current workbook or to a new workbook file. You can also copy a worksheet manually by pressing and holding the Ctrl key and then dragging the worksheet tab with your mouse to the new location.
To Move or Copy a Worksheet
- Click on the Worksheet tab of the sheet you wish to copy.
- Right-click and choose Move or Copy from the contextual menu.
Or
Click the Format button on the Home Ribbon under the Cells group and choose Move or Copy Sheet under the Organize Sheets category. - Select the Workbook into which you wish you copy the worksheet (the default is the current workbook).
- Select the location of the new sheet in the Before Sheet list box.
- Click the check box next to Create a Copy to copy the worksheet rather than move it.
- Click OK.
Similar Posts:
- Reposition Worksheets in Excel
- Open Two Excel Workbooks with the Same Name
- Shortcut Keys in Excel
- Move Text using Drag and Drop in Word 2007
- Grouping Worksheets in Excel
- Using Relative References in Excel
- Importing Data from Excel
