Excel New Sheet Shortcut
MS Excel is a powerful spreadsheet program that can work with vast amounts of data. When we create a spreadsheet or a workbook in Excel, we typically get three blank sheets/ worksheets by default. Moreover, they are generally named in increasing numbers starting with the text Sheet, such as Sheet1, Sheet2, and Sheet3.
There may be scenarios when we might need more sheets than the default ones. In such scenarios, we can easily insert new sheet(s) in Excel by navigating to Home > Insert > Insert Sheet. However, this method is a little time-consuming when we also have options of using shortcuts in Excel. With the shortcuts, we can cut the time to some extent and increase our work process's overall speed and productivity.
Therefore, we discuss some useful shortcuts to insert/ add new sheet(s) in MS Excel in this article. This article also covers shortcuts to insert multiple sheets in Excel.
'New Sheet' Shortcuts in Excel
Although there are various ways to insert or add a new sheet in Excel, the easiest and fastest ways involve shortcuts. The following are some of the essential methods of using the 'New Sheet' shortcut to insert a worksheet in Excel:
Let us now discuss each of the above methods in detail:
Insert New Sheet by using the Keyboard Shortcut
Excel allows users to insert a new worksheet or sheet using the following two keyboard shortcuts:
Both of these keyboard shortcuts work perfectly. However, we might need to activate the function keys by pressing the 'Fn' key on the keyboard. It may be required because the keyboard shortcuts have the function keys, such as F11 and F1. Besides, this may not be required for some keyboards based on the system settings.
Although we can use any of the above-listed shortcut combinations, let us try 'Shift + F11' to insert a new sheet in the following workbook:
It is important to know that the new sheet is inserted to the left side of the active sheet when we use the keyboard shortcut.
Insert Multiple Sheets with Keyboard Shortcut
There are two different methods to insert multiple sheets in Excel using the keyboard shortcut:
Method 1: To insert multiple sheets, we can press the F11 key by holding the 'Shift' key multiple times for each sheet. This way, Excel will keep inserting new sheets in a sequence of increasing numbers.
For example, if we use this method continuously, we will have sheets named 'Sheet1, Sheet2, Sheet3, and so on.
Apart from this, if we delete any sheet and try to insert a new one again, Excel will still follow the previous sequence. For example, suppose we delete the Sheet3 and then insert a new sheet using the keyboard shortcut Shift + F11. In this case, Excel will insert a Sheet4 as the new sheet instead of Sheet3.
It is because we have already inserted Sheet3 earlier and deleted it. Excel typically keeps a count of the total number of inserted sheets, including the deleted ones.
Method 2: Instead of using the shortcut key multiple times to insert several sheets, we can highlight or select the number of desired sheets and then use the shortcut key once. This method comes in handy when we need to insert more sheets than normal. However, the selected sheet tabs must be adjacent.
When selecting multiple sheets, we need to use the Shift key with the mouse button. Alternately, we can use the following shortcut combination:
Let us understand this method with an example:
That is how we can insert one or more sheets in Excel by using the keyboard shortcut keys.
Insert New Sheet by using the Sheet Tab Shortcut
Excel contains a sheet tab at the bottom of the window, displaying all the sheets of the active workbook. Additionally, there is a plus (+) icon next to the sheet tabs that can be clicked using the mouse. This Plus icon is typically a shortcut that helps users to insert a single sheet with a click. The Plus icon in a sheet tab is usually referred to as the 'New Sheet Icon'. Unlike the previous shortcut, the sheet tab shortcut or new sheet icon inserts a new sheet to the right side of the active sheet.
In Excel 2010 and earlier, the new sheet icon looks like an icon of a worksheet. However, the icon is still situated next to sheet tabs, just like the other Excel versions.
Insert Multiple Sheets with Sheet Tab Shortcut
Although we can insert multiple sheets by clicking on the New Sheet icon several times, there is an alternate way to do this task effectively. The alternate method includes the use of an insert sheet command and the dialog box. Furthermore, the new sheets are inserted to the right side of the existing sheets by using this method.
We need to follow the steps discussed below to insert multiple sheets using the Sheet Tab shortcut or the Insert command:
It must be noted that the selected sheets must be adjacent, and we must select the same number of sheets (or sheet tabs) that we want to insert into our workbook.
How to insert a new sheet with existing sheet data in excel using a shortcut?
Although we can add or insert new blank sheets in Excel using the shortcuts discussed above, sometimes, we may need to create a new sheet with existing data from another sheet of the workbook. Typically, we copy data from the existing sheet and then create a new blank sheet and paste data from the clipboard to perform this task. However, we can also concisely do this job with the following steps: