View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ck ck is offline
external usenet poster
 
Posts: 52
Default Insert Row and keep merged cells formatting

I have a spreadsheet with several merged cells in a row. When I insert a new
row, it copies all the formatting of the row above or below into the new row
except that of the merged cells, e.g. the merged cell is once again broken
down into 2 cells. Is there a way that the merged cells can automatically be
copied over to the new row when I insert a row without having to use format
painter, etc.?