You can add tabs, or worksheets, in Excel to separate data and make it more accessible. By default, Excel provides one worksheet (three if you are using Excel 2007), but you can create additional worksheets as you wish.
Step
Method 1 of 3: Adding One Worksheet
Step 1. Start Excel via the Start menu (Windows) or the Applications folder (Mac), then open the workbook you want to insert the worksheet into
When you open Excel, you will be asked to select a file.
Step 2. Click the "+" button at the end of the worksheet tab to add a blank worksheet to the right of an existing worksheet
- You can also press Shift+F11 to add a worksheet in front of the selected worksheet. For example, if you select Sheet1 and press Shift+F11, Sheet2 will be added in front of Sheet1.
- To create a new tab in the Mac version of Excel, press Command+T.
Step 3. Make a copy of the working paper by selecting a specific paper, pressing Ctrl/Opt, and draw the worksheet.
Excel will make a copy of the worksheet and the data in it.
If you want to copy multiple worksheets at once, press and hold Ctrl/⌥ Opt while clicking the worksheet you want
Step 4. Double click the tab to rename it
Once the text is selected, you can name the worksheet any name.
Step 5. Right-click one of the tabs, then select "Tab Color" to change the color
You can choose from a variety of default colors, or click "More Colors" to create your own.
Step 6. Change the number of default workbooks for the new workbook
You can change Excel settings to include more or less worksheets when you create a new workbook.
- Click the File tab or Office button, then select "Options".
- On the "General" or "Popular" tab, find the "When creating new workbooks" section.
- Change the value in the "Include this many sheets" option.
Step 7. Click and drag the tabs left or right to rearrange the tabs
Once you have a few tabs, you can click and drag them. Drag the tab left or right to move it to a new position. This position shift will not affect formulas or data references.
Method 2 of 3: Adding Some Worksheets
Step 1. Hold down Shift, then select the number of worksheets you want to add
For example, if you want to add three worksheets at once, hold down Shift while selecting three worksheets. In other words, you must have three worksheets before you can quickly create three worksheets through this step.
Step 2. Click the "Insert " button in the Home tab
You will see an additional "Insert" option. Make sure you click the "▼" arrow to open the additional menu..
Step 3. Select "Insert Sheet
" Excel will add blank worksheets according to the number of worksheets you selected. The worksheet will be added to the left of the first worksheet you selected.
Method 3 of 3: Inserting a Worksheet Template
Step 1. Create or download the template you want to use
You can turn any workbook into a template by saving it in the "Excel Template (*.xltx)" format. The template file will be saved in the Templates folder. Alternatively, you can also download various templates from Microsoft when creating a new file.
Step 2. Right-click the tab you want to insert the template in front of
The new template will be inserted in front of the tab of your choice.
Step 3. Select the "Insert" option from the context menu
You will see a new window where you can select the object you want to insert.
Step 4. Select the template you want, then click "OK"
Templates that have been downloaded and saved will appear in the "General" tab.
Step 5. Select a new tab
A new tab (or a series of tabs if the template has more than one worksheet) will be inserted in front of the tab you selected.
Tips
- You can apply changes to multiple tabs at once by grouping them. Hold down the Ctrl key while clicking a tab to create a group of tabs. To group a series of tabs, hold down the Shift key, then click the first and last tabs you want to group. To ungroup a tab, release the Ctrl or Shift key, then click any tab.
- Tabs are easier to identify if they are given a unique name, such as a month, number, or something else that represents the contents of the tab.
