Selecting rows ...

L

lilianld

Hello everybody,

Having a long column, how can I select all empty cells in it?
Is there a trick to do that or I should select it one by one manually?

Thank you in advance for your help.
 
S

Suzanne S. Barnhill

Short of a macro, there's no way to do this except manually, but if you sort
on that column, the empty cells will sort to the top.
 
Top