In this article, I will show you how to select all cells from all worksheets.
It sounds complicated but all it takes is just 2 simple steps.
Expected Outcome
![Select all cells from all worksheets](https://dollarexcel.com/wp-content/uploads/image-121-1024x430.png)
Option 1: Select whole worksheet + Select All Sheets
Step 1: Press the small triangle
This triangle helps you select the whole sheet
![Select the whole sheet](https://dollarexcel.com/wp-content/uploads/Select-the-whole-sheet-1024x811.png)
Step 2: Right click any tab
![Press Select All Sheets](https://dollarexcel.com/wp-content/uploads/Press-Select-All-Sheets-1024x193.png)
Step 3: Done!
Isn’t it really easy but useful?
Do you find this article helpful? Subscribe to our newsletter to get exclusive Excel tips!