Save a step by naming your new sheets right when you create them.
Video Tutorial
Watch on YouTube & Subscribe to our Channel
Downloads
You're probably familiar with the plus-shaped button + at the bottom of your workbook that creates a new sheet. One click, and instantly a new sheet appears.
However, if you double-click the button instead, Excel will not only insert the new sheet, but will allow you to rename it at the same time. The sheet name is put into edit mode so that you can immediately start typing the sheet name.
If you make the double-click a habit when you add your new sheets, you'll avoid forgetting to name your sheets, and your workbooks will look clean and organized!
Let me know if this simple tip was helpful. Leave a comment or share your own favorite Excel hack below.
Thank you for a great hack!
Here is what I experienced. On an older workbook, created about 5 years ago, it did NOT work. So to test it, I started a brand new workbook, and yes, it works great! Any comments on that? I run Office 365
thx
Jesse
Hi Jess.
This hack only works if you’re adding a new sheet at the end. It’s not a standard feature or a property of the plus button. It is a coincidental convenience. Has nothing to do with older or newer workbook.
Great find by Jon by the way.
Great tip, Jon! Saves a step in naming new sheets.