How to Insert Tabs in Excel (3 Easy To Follow Methods)
In this article, you will learn three simple ways to add new worksheets in Excel.
Method 1: Adding new worksheets in Excel using the ‘Insert’ function
Step 1: Select a tab (to the left of which you wish to add a new tab)
Step 2: Right-click on the Worksheet Tab and select the ‘Insert’ option
![](https://cdn.prod.website-files.com/61f27b4a37d6d71a9d8002bc/63fcf8e46a8abf40312f120d_1jiqEUx5Fw_IMYFHK7Au3ZzViq338nCawz-MyLNWkVmfRWlh4vPy85mnFv43Ms6R0aUDTZSnIbbnrNH-7U3pljBnnL8tqOiA3CjN3249ak71hui1LEjIdVHyt55HMenMmKks7rSQvZ01fskWdtyEP48.png)
Step 3: Click on ‘Worksheet’ and select ‘OK’
A new tab will be added.
Method 2: Inserting new tabs in Excel using Keyboard Shortcuts
Step 1: Select a tab (to the left of which you wish to add a new tab)
Step 2: Press and hold the “SHIFT” and “F11” keys (“SHIFT”, “Fn” and “F11” in case of Mac)
A new worksheet will be added.
Method 3: Generating new sheets in Excel using the “+” sign on Worksheet Tab
Step 1: Select a tab (to the right of which you wish to add a new tab)
Step 2: Click on the “+” sign in the Worksheet Tab as displayed in the image below
![](https://cdn.prod.website-files.com/61f27b4a37d6d71a9d8002bc/63fcf8e4179034286192d0ec_5I_6cc99XwjGuPKIME_QPoUYxTuYwf5Wv2NYKfq6YTduUigByGqf_bDzoQMD8gFDh6iE8VKw4PFEcg5kXHnP-a7cJCxB4h2Dyw_fA5nGtsfq22qpGnxKSeIwSNe0T29bbqbShFBh-d0vQIMVlNcbVxk.png)
A new tab will be added.
Analyze your live financial data in a snap in Google Sheets
Are you learning this formula to visualize financial data, build a financial model, or conduct financial analysis? In that case, LiveFlow may help you automate manual workflows, update numbers in real-time, and save time. You can access various financial templates on our website, from the simple Income Statement to Multi-Currency Consolidated Financial Statement. Are you interested in this product but are an Excel user? That’s not a problem at all. You can connect Google Sheets to Excel quickly.
To learn more about LiveFlow, book a demo.
![](https://cdn.prod.website-files.com/61f27b4a37d6d71a9d8002bc/63094d4ff22c84c91b065734_k_tknKuBvQLC26yRFvG3KBrgiZe2EN-g1RsVh1HFq4LYumJDh7_qMQ31VLFPYg5OqPq2GaUG58MNZo7Nj0HVd1yY_QitXvo0kQ5lSCEfOBkd4Ugiu3m72sqHO7vI7cuq_eEk-MRWGa_ry8EaHRtKsN8.gif)
You can learn about other Excel and Google Sheets formulas and tips that are not mentioned here on this page: LiveFlow‘s How to Guides