How To Select All Cells From All Worksheets

How To Select All Cells From All Worksheets
Table of Contents

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
Select all cells from all worksheets

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
Select the whole sheet

Step 2: Right click any tab

Press Select All Sheets
Press Select All Sheets

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!

Share on facebook
Share on google
Share on twitter
Share on linkedin
Share on pinterest
International Open Academy

Join Our Newsletters!

JOIN OUR NEWSLETTERs!