Shortcut to insert worksheet with sheet name in Excel

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

About Anson

I’m Anson, having versatile experience in Business Process Outsourcing, Finance & Accounting, Information Technology, Operational Excellence & Business Intelligence. I'm currently working in a MNC in Bangalore, India. Learning anything new has always been my passions and if its related to Business and Technology then, I love it. This website/blog is an outcome of my passion towards it and I have been blogging since 2012. Outside business and technology I’m a movie freak who spends hours together watching and learning Cinema.

One Comment

  1. Pingback: Shortcut to add/insert worksheet in excel with ...

Leave a Reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.