Hints and tips home » Excel hints and tips » Make a quick copy of a worksheet

Make a quick copy of a worksheet

Hold down the Ctrl key, then click and drag on a sheet tab to make a copy of that sheet. Though this process usefully copies the formats of the original sheet, note that any Range Names you have on the original sheet will be duplicated too.

To make a copy of a worksheet's contents and formats without duplicating range names: (1) Ensure that you have a blank worksheet to paste to. (2) On the sheet to copy, click on the sheet selection square to the left of Column A's heading to select the whole sheet. (2) Copy the whole sheet. (3) Paste to the blank worksheet.

Added by Alan on 5th September 2006

More Excel hints and tips, like:

• Adjusting the Elevation and Rotation in a 3-D Chart
• Freeze Rows and Columns to keep lables displayed
• The dual nature of toolbar buttons