EXCEL: Worksheet Tabs, Copy

Here's another tip on Excel's worksheet tabs (at the bottom).  One example of when you may want to copy a worksheet into the same workbook would be if you had a spreadsheet completed for figures entered in 2010 and now you want a new worksheet to enter 2011 figures.  To do this:

1. Right click on the worksheet tab you are currently using (at the bottom of the sheet)
2. Choose Move or Copy
3. Choose Create a Copy, Move to End

Now you can re-name the 2010 worksheet to "2010" and the copy you just created to "2011"!