Arrow left
Back to guides
Excel Tips

How to Select Multiple Tabs in Excel (3-Step Guide)

In this article, you will learn how to select more than one spreadsheet in Excel.

Why do many sheets need to be selected in Excel? 

There are various reasons why you might need to select multiple tabs in Excel, including:

  • Formatting: If you want to apply the same formatting to multiple sheets in your workbook, selecting them all at once can save time.
  • Data entry: If you have a data entry task that requires inputting the same data across multiple spreadsheets, selecting them all at once can make the task more efficient.
  • Calculations or data analysis: If you want to perform the same calculations across multiple sheets, selecting them all at once can save time and ensure consistency.
  • Printing: If you want to print multiple spreadsheets at once, selecting them all can help you avoid having to print each sheet individually.

Overall, selecting multiple sheets in Excel can help you perform tasks more efficiently and effectively, and can save you time in the long run.

How to select multiple tabs in Excel?

To select multiple spreadsheets in Excel, follow the below steps:

Step 1: Click on the first tab you want to select.

Step 2: Press and hold down the “CTRL” (“Command” in case of Mac) key on your keyboard and then click on the additional tabs you want to select.

To select tabs that are placed in order, you can use the “Shift” key. Just click on the first tab, press and hold down the “Shift” key and then click on the last tab in the range. All sheets in between the first and last sheet will be automatically selected.

Step 3: The selected spreadsheets will be highlighted as shown in the picture below, and you can now perform operations on all the selected sheets simultaneously.

Image displaying two tabs being highlighted when selected together in Excel

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.

Automate any custom financial dashboard in Google Sheets with LiveFlow

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

Learn how to do this step-by-step in the video below 👇

Automate financial reporting with LiveFlow

Want to eliminate manual updates of your Excel & Google Sheets models?

Yes, show me how

Need help?

Our team is here to help you any time between 9am and 10pm EST.
Check Icon
Email us at:

Liked this article? Then you'll love the ones below