Quick way to select all cells

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 2016

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.