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

Sumit Bansal
Hello there! I'm Sumit Bansal, founder of trumpexcel.com and an Excel MVP. I started this website in 2013 with a simple goal: to share my love for Excel through easy to follow tips, tutorials and videos. I'm here to help you get the best out of MS Excel to save time and boost your productivity.

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

Leave a Comment

FREE EXCEL E-BOOK

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

FREE EXCEL E-BOOK

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

Free Excel Tips EBook Sumit Bansal

FREE EXCEL E-BOOK

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