Thread: Combining Rows
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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