ExcelBanter - Sort ascending requires merged cells to be the same size.

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Sort ascending requires merged cells to be the same size. (https://www.excelbanter.com/excel-discussion-misc-queries/212987-sort-ascending-requires-merged-cells-same-size.html)

Peterbrum

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.

joel

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.

Gord Dibben

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.

All times are GMT +1. The time now is 08:52 PM.