Quick way to select all cells

Excel
2010
/ 2013
/ 2016

This tip will help you to select all cells in the worksheet in one click.

A quick way to do so is to click the triangle at the intersection of the row headers and column headers:

Select all cells in Excel 2010

Ask a Question

We use your email only for the communication between you and our team.

If you have any questions or suggestions, please feel free to ask OfficeToolTips team.

Thank you for visiting OfficeToolTips

We are glad to help you in your work. However, you are using ad blocker and our efforts will not be rewarded.

Please consider disabling ad blocker before continuing the reading.