MICROSOFT OFFICE TUTOR: Create a quick copy of your Excel worksheet (Excel 2000/2002/2003/2004/2007)
Posted on April 20th, 2009 by Eli Journals
You can save yourself a lot of time by copying an existing Excel worksheet. That way, if you want to create a similar worksheet, you can skip most of the formatting. Here’s a quick method for copying worksheets:
- Press and hold down the [Ctrl] key ([option] key on the Mac).
- Click and drag the tab of the worksheet you want to copy (it must be the active worksheet). An arrow will display just above the worksheet tabs as you drag the worksheet, as shown in Figure A.
- Drop the worksheet where you want to place the copy. Its new worksheet tab displays, as shown in Figure B.
Figure A: Drag the Excel worksheet until the arrow is in the place where you want the copy of the worksheet to go.
Figure B: Your new Excel worksheet copy displays in the place to which you dragged it.
Filed under: Microsoft Office Tutor