Selecting rows ...

[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.

 

[Anne Troy]

You can click in any cell in the column and hit Table-->Select-->Column.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com

 

[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.