| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
inserting rows keeping the merged cells
I would like to insert a row in a worksheet and keep all the format of the
row above. This includes where the cells have been merged. All the formating remains except that the cells become individual and then have to be merged. Any suggestions welcome |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
inserting rows keeping the merged cells
copy the line above
select the line below ctrl + to replicate the line above (all formats, formulae, values, merging) press delete to remove formulae and values -- Allllen "Syd100" wrote: I would like to insert a row in a worksheet and keep all the format of the row above. This includes where the cells have been merged. All the formating remains except that the cells become individual and then have to be merged. Any suggestions welcome |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to check for cells merged across rows | Excel Discussion (Misc queries) | |||
| Seperate Merged Cells with multiple rows? | Excel Discussion (Misc queries) | |||
| Blank Rows from Merged Cells in Drop Down Menu | Excel Discussion (Misc queries) | |||
| identically size merged cells for sorting rows | Excel Discussion (Misc queries) | |||
| Inserting line breaks into merged text cells. | Excel Discussion (Misc queries) | |||
Linear Mode
