A Quick Way to Copy an Excel Worksheet

Share this article...

Here's a simple Excel secret in how to duplicate a Worksheet

So you have worked on your masterpiece worksheet for Dec 09, tested all the formulae, sorted out all the pretty formatting and colours and you now want to duplicate this and call it Jan 10

Click on the tab and hold - it should look like this... (notice the little blank document icon on the cursor and the little black triangle on the left edge of the tab)

Whilst holding down the mouse button Hold down the Ctrl key on your keyboard - you should now see a tiny + symbol appear in the blank document icon like this...

Still holding the Ctrl key - drag your held mouse cursor to the right so that the little black triangle moves to a new position - notice the new position of the black triangle like this...

Still holding the Ctrl key - let go of the mouse button - Hey Presto! - a new tab appears like this

To rename the new sheet Double click the tab (it will highlight) - type the new name of your sheet e.g. Jan 10 then click in a cell on the new Worksheet

Are you using Excel on a Mac?

Instead of using the Ctrl key described above use the Option key instead (highlighted in yellow)

Prefer to watch a 60 second video? (remember to turn on the sound)