Combining Rows
Data|List was added in xl2003. (But the Format|autoformat has been there pretty
long, IIRC.)
The enhancement to Edit|Find based on format was added in xl2002.
Harlan Grove wrote:
"Herbert Seidenberg" wrote...
This could be done without any formulas:
Select cells plus top blank row.
...
So OP may need to insert a blank row above the data.
Edit Find Options Format Choose Format from Cell
Select any white cell Find All SHIFT+END Close
...
This requires Excel 2003, doesn't it?
--
Dave Peterson
|