| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How locate merged cells in Excel
I want to sort columns but some cells are merged. How do I locate the merged
cells - or is there a way of unmerging all merged cells? |
|
#2
|
|||
|
|||
|
Select all cells and hit the "merge" button, just like you were going to
merge those cells. If there are any merged cells within your workbook it will unmerge them first. -- Regards, Dave "LESTEREDEN" wrote: I want to sort columns but some cells are merged. How do I locate the merged cells - or is there a way of unmerging all merged cells? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| retrieve text from merged cells | Excel Worksheet Functions | |||
| How to stop Excel from automatically selecting cells? | Excel Discussion (Misc queries) | |||
| Filling cells (autofil?) in Excel 2003 | Excel Discussion (Misc queries) | |||
| Charting of Merged Cells | Excel Discussion (Misc queries) | |||
| why can't i enter text into merged cells in excel | Excel Worksheet Functions | |||
Linear Mode
