| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert rows and keep merged cells in the inserted row
Hi,
I have a simple spreadsheet with 15 columns and appr. 30 rows. At Column D + E I have merged cells horisontally in almost every row - except af few ones. When I want to insert a new row(with merged cells), then it's inserted but not merged. I mark the row on the rownumber, rightclick the mouse and do "insert". Can I do something, so the merged cells in the marked row will be copied into the inserted row? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Insert rows and keep merged cells in the inserted row
Standard advice in this & other Excel newsgroups is don't use merged cells.
There is normally a better alternative. In the archives of the group you'll find many more reports of problems than you'll find solutions. It sounds like you've found one of the problems. -- David Biddulph "Buggelsgaard" wrote in message ... Hi, I have a simple spreadsheet with 15 columns and appr. 30 rows. At Column D + E I have merged cells horisontally in almost every row - except af few ones. When I want to insert a new row(with merged cells), then it's inserted but not merged. I mark the row on the rownumber, rightclick the mouse and do "insert". Can I do something, so the merged cells in the marked row will be copied into the inserted row? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change colour of cells when content is altered/changed BUT NOT TO INSERTED OR DELETED ROWS | Excel Discussion (Misc queries) | |||
| Insert Row and keep merged cells formatting | Excel Discussion (Misc queries) | |||
| automatically insert formula when new rows are inserted | Excel Worksheet Functions | |||
| AUTO INSERT A COLUMN'S FORMULA IN MANUALLY INSERTED ROWS | Excel Worksheet Functions | |||
| Insert Row and Maintain Merged Cells | Excel Discussion (Misc queries) | |||
Hybrid Mode
