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




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)