Can I select all cells from all worksheets in Excel?

I want to select every cell in an Excel workbook from all sheets at the same time. Is there any keyboard shortcut or VBA code to manage this?

2

2 Answers

Click on the left-most tab (i.e., the tab for the first sheet). Shift+click on the right-most tab.  You have now selected all sheets. 

Finally, click on the triangle to the left of the A column header, above the 1 row label, and below the name box.  You have now selected all cells on all sheets.

I have found my solution.

I looped through all worksheets and put inside the loop some code that selects every cell in a sheet.

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password

Post as a guest

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

You Might Also Like