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...

Design Your Excel Training

checklist

Say Thank You

Has somebody at Easykey impressed you?

Pick a Reward

Customer Thanks

  • Thanks No. 179

    Sushila has awarded Barry a Virtual Cake for "helping me set up some complicated systems during...

  • Thanks No. 178

    Emma has awarded Dominic a Virtual...

  • Thanks No. 177

    Catriona McMullen has awarded Dominic a Virtual Beer because "Thanks for sorting problem with...

  • Thanks No. 176

    Sam has awarded Dominic a Virtual Beer because "Brilliant service as...

This website uses cookies to help us improve your experience.
By using our website you accept our Privacy Policy and use of cookies.