| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort ascending requires merged cells to be the same size.
The list of names that I tried to sort does not have any merged cells.
Please tell me what might be wrong. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sort ascending requires merged cells to be the same size.
You must have merged cells. Select a worksheet range object (like a column,
row, or entire sheet) then go to menu - Format - Cells - Allignment and unclick the Merged Cell box. "Peterbrum" wrote: The list of names that I tried to sort does not have any merged cells. Please tell me what might be wrong. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sort ascending requires merged cells to be the same size.
You've got some merged cells somewhere in the range.
Re-check. Gord Dibben MS Excel MVP On Tue, 9 Dec 2008 08:31:01 -0800, Peterbrum wrote: The list of names that I tried to sort does not have any merged cells. Please tell me what might be wrong. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| DATA SORT REQUIRES IDENTICALLLY MERGED CELLS???? HELP PLEASE | Excel Worksheet Functions | |||
| Odd error - "This operation requires merged cells..." | New Users to Excel | |||
| requires that merged cells must be identically sized? | Excel Discussion (Misc queries) | |||
| getting msg: cannot sort merged cells not same size | Excel Discussion (Misc queries) | |||
| Sorting merged cellsHow do I sort merged cells not identically siz | Excel Worksheet Functions | |||
Hybrid Mode
