Create a Worksheet in Excel
MS Excel or Microsoft Excel is one of Microsoft's most powerful spreadsheet software. It comes with a distinct range of built-in features and functions to help us record large amounts of data in a worksheet. By default, whenever we create a new workbook in Excel, we get three worksheets, namely Sheet 1, Sheet 2, and Sheet 3. However, there may be cases when we may need one or more additional worksheets to record our data. Excel also provides such a useful option or feature to the users.
This article discusses various step-by-step tutorials on creating a worksheet in Excel. Before discussing the process of creating a worksheet in Excel, let us briefly discuss the Introduction to Excel worksheet.
What is a Worksheet in Excel?
An Excel worksheet is the single sheet used in Excel documents, which contains groups of cells organized in rows and columns. Each worksheet allows users to record or write data within the cells as well as perform various operations with the recorded data.
The worksheets are located in the bottom area of the Excel window, which is known as the Sheet tab. The new workbook has the following sheets by default:
We have three worksheets in the Sheet tab in the above image, such as Shhet1, Sheet2, and Sheet3. To view any of the desired worksheets, we need to click on the name of that particular sheet from the Sheet tab.
How to create/ insert a worksheet in Excel?
In Excel, we have multiple ways to perform the most common tasks. Likewise, when it comes to creating a worksheet, we can use different methods, such as:
Let us discuss each method in detail:
Creating a worksheet using the Sheet tab
The easiest method to create a worksheet within the workbook is to use the Sheet tab. Excel displays an additional Plus icon in the Sheet tab, called the 'Add/Insert Worksheet button' in general. We can instantly create a worksheet in our Excel workbook using this plus icon or button. Also, clicking this icon multiple times allows us to create multiple worksheets accordingly.
As soon as we click the plus icon in the Sheet tab, a new worksheet is created to the right-most side of the last worksheet name. By default, the worksheet names are created in sequential order. For example, if we have three worksheets, such as Sheet1, Sheet2, and Sheet3, in our workbook and click the plus icon, the newly created worksheet will be named Sheet4.
Creating a worksheet using the Contextual Menu
The contextual menu refers to the right-click menu options accessed on the corresponding feature. It is another easy method to create a worksheet in the workbook. We can follow the steps discussed below:
When we use this method, the new worksheet is created on the left side of the selected sheet instead of the most-last sheet in the Sheet tab. Thus, we must select the worksheet carefully when pressing the right-click button. Besides, the naming approach is the same. We can use this method again and again for each additional worksheet like other methods.
Creating a worksheet using the Ribbon
Excel is a feature-rich spreadsheet software, and most of the features are placed on the Ribbon. Accessing the ribbon tools is one of the basic tasks of Excel. The Ribbon also allows us to use the tool to create a worksheet. We can perform the following steps to create a worksheet using the Ribbon within our Excel workbook:
Creating a worksheet using the Keyboard Shortcuts
Excel has many built-in or predefined keyboard shortcuts that help quickly perform most tasks. We can also create a new worksheet within our Excel workbook using the keyboard shortcut. Excel has two different keyboard shortcuts to create a worksheet quickly without using the mouse. We can either use Shift + F11 or Alt + Shift + F1. However, we may need to use the Fn function key for some keyboards to activate function keys, such as F1, F2, … so on.
To use the keyboard shortcut for creating a worksheet, we can perform the following steps:
When we use the keyboard shortcut to create a worksheet in our workbook, the sheet is inserted to the left side of the selected or active sheet. Also, creating multiple worksheets is possible with keyboard shortcuts.
Creating a worksheet using VBA
VBA (Visual Basic for Applications) is one of the advanced features of Excel that allows us to perform most of the tasks using code. While creating a worksheet, Excel offers us to execute a simple macro or script through VBA to create the worksheet at the desired location in the Sheet tab.
We can perform the below steps to create a worksheet using VBA in Excel:
The above code will look like the following image:
Similarly, when we need to create a worksheet after any specific sheet in the Sheet tab, we can use the following code:
In the above code, we have to specify the existing worksheet name, after which we want to create a worksheet in place of SheetName.
How to create multiple worksheets in Excel?
Although we can use any of the above-listed methods multiple times to create multiple sheets within the workbook, it will be a lengthy process. Besides, Excel also allows us to insert multiple worksheets at once. To create many sheets at once, we typically need to select or highlight the same number of existing worksheets to notify Excel how many we require.
When selecting worksheets in Excel, we need to follow below rules:
After selecting the desired number of worksheets, we can create a worksheet using the Contextual Menu, Ribbon, or Keyboard Shortcuts.
Example: Creating 3 Contiguous Worksheets in Excel
Let's suppose that we have a newly created workbook with default worksheets, such as Sheet1, Sheet2, and Sheet3. We want to create three more worksheets in our workbook. To do this, we must go through the following steps:
In this way, we can quickly create multiple worksheets in a few clicks.
Note: To sequence the worksheets or arrange the order of worksheets in the Sheet tab, we can drag and drop the desired sheet using the mouse.
Important Points to Remember