View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
kiever1
 
Posts: n/a
Default How to merge rows?

Select the rows you want to merge & click the merge icon.
Otherwise, select the rows Format Cells Alignment Merge Cells


Thank you for answer, but
It is merge cells, but I need merge rows such as

This is I have:

A B

|---|-------------------------|---------------------|
| 1 | | B1 |
|---| A1 |---------------------|
| 2 | | B2 |
|---| |---------------------|
| 3 | | B3 |
|---|-------------------------|---------------------|


This is I need:

A B

|---|-------------------------|---------------------|
| 1 | | B1 |
| | A1 | |
| | | OldB2 |
| | | |
| | | OldB3 |
|---|-------------------------|---------------------|