Shortcut to insert worksheet with sheet name in Excel

Share on facebook
Share on twitter
Share on linkedin

Shortcut to Insert Worksheet with Sheet Name (with Images)

What is it: It’s a shortcut to insert worksheet with the sheet name in Microsoft Excel.

Why is it important: When you want to insert an additional worksheet in excel with a particular name for that sheet,

With this shortcut you can do both the activities of inserting the sheet and renaming it, in a single step and thus save your time.

How to : You should have ASAP Utilities excel add-on installed in your computer to enjoy this feature. A quick note if you are not familiar with ASAP Utilities:




It is a highly recommended powerful Microsoft Excel add-on enriched with more than 300 time saving tools which will speed up your experience of working with MS Excel.

Steps to insert worksheet with the sheet name:

Step 1: Click on any cell in the active sheet.

Step 2: Press Ctrl + Alt + N in the keyboard

Step 3: A pop-up window something like the below appears requesting you to fill in a name for your new sheet. Type the name that you want to give for the new sheet and click OK (Here I have used the name as ‘Test’).

insert worksheet

Step 4: You are done with creating and renaming the worksheet! A new sheet would have created next to the last worksheet with the name that you have given.

insert worksheet

Anson Antony

Anson Antony

Anson is a contributing author and founder at ASKEYGEEK.com. Learning anything new has always been his passion, ASKEYGEEK.com is an outcome of his passion for technology and business. He has got a decade of versatile experience in Business Process Outsourcing, Finance & Accounting, Information Technology, Operational Excellence & Business Intelligence. During the tenure, he had worked for organizations like Genpact, Hewlett Packard, M*Modal and Capgemini in various roles and responsibilities. Outside business and technology, he is a movie buff who spends hours together watching and learning Cinema and a Film Maker too!

One Response

Leave a Reply

Your email address will not be published. Required fields are marked *

small_c_popup.png

Let's have a chat

Fill out the form below to consult with us