| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
find and demerge merged cells
Hi
I have a worksheet with cells merged at many places.So I am unable to sort properly. I want a program to find and demerge all merged cells. Thanks Jerome |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
find and demerge merged cells
Click on the Select All button (to the left of the Column A button)
Choose FormatCells Select the Alignment tab Click the Merge Cells check box to remove the check mark (you may have to click twice) Click OK jeromek wrote: I have a worksheet with cells merged at many places.So I am unable to sort properly. I want a program to find and demerge all merged cells. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Demerge cells and copy data | Excel Worksheet Functions | |||
| demerge mercge cells | Excel Worksheet Functions | |||
| Find Merged Cells | Excel Discussion (Misc queries) | |||
| Is there an easy way to find/display merged cells in excel | Excel Worksheet Functions | |||
| how can I find merged cells in a large xl-file | Excel Discussion (Misc queries) | |||
Linear Mode
