# How to Sort and Ignore Blanks in Google Sheets

Sorting data and ignoring blanks in Google Sheets is a helpful way to organize and analyze your data. Here's a step-by-step guide on how to do this:

## Remove or Ignore Blanks While Sorting

- Click on an empty cell in your sheet where you want to display the sorted data without blanks.
- Enter the formula
`=SORT(FILTER(A1:A, A1:A <> ""),1,TRUE)`

and press Enter.- Replace
`A1:A`

with the range of cells you want to sort. - Replace
`1`

with the column number by which you want to sort the data. - Replace
`TRUE`

with`FALSE`

if you want to sort the data in descending order.

- Replace
- The sorted data without blanks will be displayed in the cell where you entered the formula.

## Example:

Let's say you have a list of names in cells A1 to A10, and you want to sort these names in ascending order while ignoring the blank cells.

- Click on an empty cell, for example, B1.
- Enter the formula
`=SORT(FILTER(A1:A10, A1:A10 <> ""),1,TRUE)`

and press Enter. - The sorted names without blanks will be displayed in column B.

Remember that sorting data using the `SORT`

and `FILTER`

functions will not change the original data in your sheet. If you want to modify the original data, you can copy the sorted data and paste it as values (Edit > Paste Special > Paste Values Only) over the original data range.

Did you find this useful?