See all How-To Articles

How to Select All Cells With Values in Excel

In this tutorial, you will learn how to select all cells with values in Excel.

 

select all cells with values final data

 

Select All Cells With Values

In Excel, it’s easy to select all cells in a sheet or range, but it’s also possible to select all cells containing values at once with just a little more work. Say you have the data set below, with some values missing for Sales Amount (Column D). The following example will show how to select all cells in the range at once, excluding those without values.

 

select all cells with values initial data

 

1. Select the entire range (e.g., B3:D12) and in the Ribbon, go to Home > Find & Select > Go To Special.

 

select all cells with values go to special

 

2. In the Go To Special window, select Constants and click OK.

When you select Constants, Numbers, Text, Logicals, and Errors are all checked by default. This means that all four types of data will be selected. If there are some types you don’t want to select, uncheck them.

 

select all cells with values go to special 2

 

As a result, cells that are not empty are selected, while empty cells (D5, D7, D9, and D10) are not.

 

select all cells with values final data