| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with merged cells
I have a number of vertically merged cells showing one piece of text for all
merged cells in several different columns throughout my spreadsheet. Ex. Column J has rows 2-16 merged and showing C18378 only on row 16 And column L has rows 2-16 merged and showing 15138459 only on row 16 But Column J also has rows 17-30 merged showing D78555 only on row 30 And column L has rows 17-30 merged and showing 13931973 only on row 30 .. . . etc. I need to unmerge all of them and show the text in every cell. My spreadsheet has over 30,000 rows in it; how can I do this easily? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Merged Cells | Excel Discussion (Misc queries) | |||
| Autofit Merged cell Code is changing the format of my merged cells | Excel Discussion (Misc queries) | |||
| how do i link merged cells to a merged cell in another worksheet. | Excel Worksheet Functions | |||
| Merged Cells | Excel Discussion (Misc queries) | |||
| Sorting merged cellsHow do I sort merged cells not identically siz | Excel Worksheet Functions | |||
Threaded Mode
