Increase Excel Tab Numbering as You Create a Copy

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.

Excel Tab Numbering

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:

Excel Ebook Subscribe

FREE EXCEL BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

2 thoughts on “Increase Excel Tab Numbering as You Create a Copy”

  1. It also seems to work if you put some text before the number, like Month (1), QA Sample Set (1)…

Comments are closed.