This is one awesome Excel Tab Numbering tip and the credit goes to Scott of Excel Zoom.
He has some amazing articles on his website, and I am going to copy this tip shamelessly here [with his permission of course]
If you have a workbook where the tab’s names are numbers (for example 1, 2, 3.. or 2020, 2021, 2022..) then you are going to love this tip.
Here it is – Give the desired number to your tab and put it in round brackets – (1). Now when you create a copy of the worksheet, the number automatically gets incremented by 1. So (1) becomes (2).
Similarly (2013) would become (2014) when a copy is created.
Why Tab Numbering Trick Works
When you create a copy of a worksheet named Sheet1, it becomes Sheet1 (2), as excel can not have two sheets with the same name. Similarly if copied again, it becomes Sheet1 (3) and so on.
So now when we name it (1) and copy it, the number is automatically increased by 1.
Other articles you may also like:
hi sumit ji it is not working in my excel 2010
It also seems to work if you put some text before the number, like Month (1), QA Sample Set (1)…