View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rich F Rich F is offline
external usenet poster
 
Posts: 10
Default Merge the same group of cells down a column quickly

I've got 900 rows of data in which each needs to have cells 1:3 merged and
centered (so, a1:a3, b1:b3, c1:c3, etc). Is there any fast way of doing this
besides selecting the same three cells in each row, hitting Merge & Center,
and then moving on to the next row? Trying to create a macro has been
fruitless and quite frustrating.

Im using 2007.

Thanks in advance!
--
Rich F