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?
22 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.