Share this article...

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

Microsoft Excel Tips

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... Excel Tab (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... Tab showing +

 

  • 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...tab triangle new position

 

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

 

  • 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)

option key mac

 

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

Share this article...
Was this article helpful? Add your comment below...

Coronavirus COVID-19 Pandemic Policy

Design Your Excel Training

checklist

Say Thank You

Has somebody at Easykey impressed you?

Pick a Reward

Customer Thanks

  • Thanks No. 229

    Roe Hill has awarded Dominic a Virtual Beer because...

  • Thanks No. 228

    Sandra has awarded Dominic a Virtual Wine because "Dominic showed the usual Easykey good service....

  • Thanks No. 227

    Kim has awarded Dominic a Virtual Cookie because "fixed computer this morning without too much up heavel for...

  • Thanks No. 226

    Gary has awarded Dominic a Virtual...