187k views
5 votes
Suppose you have a range of cells with numbers and a few blank entries. if you sort the range in ascending order (smallest to largest), where will the blank cells be located after sorting?

User Gpbaculio
by
7.6k points

1 Answer

3 votes
After sorting, the blank cells will be located at the bottom of the filled cells.
For the Microsoft excel software, the software has been designed in such a way that the empty cells will always be below the filled cell after sorting action is performed on the cells. Excel typically use blank column to set a data range.
User Lambros
by
8.1k points