Excell Alphabetizing & Sorting
 

When I try to alhabetize aan excell sheet I am working on, it says all merged
cells must be the same size. How is this overcome?

DG
--

Excell Alphabetizing & Sorting
 

Remove the merged cells?????

Muddled wrote:

When I try to alhabetize aan excell sheet I am working on, it says all merged
cells must be the same size. How is this overcome?

DG
--

--

Dave Peterson

Excell Alphabetizing & Sorting
 

iI suppose that would work, Except that it would mean completely remaking my
sheet. Also I Know I have done this before-- Just don't recall how.
DG
-


"Dave Peterson" wrote:

Remove the merged cells?????

Muddled wrote:

When I try to alhabetize aan excell sheet I am working on, it says all merged
cells must be the same size. How is this overcome?

DG
--

--

Dave Peterson

Excell Alphabetizing & Sorting
 

You have done it before?

Yes...........if all the merged cells in the sort range were the same size.


Gord Dibben MS Excel MVP

On Sat, 19 May 2007 19:29:01 -0700, Muddled
wrote:

iI suppose that would work, Except that it would mean completely remaking my
sheet. Also I Know I have done this before-- Just don't recall how.
DG
-


"Dave Peterson" wrote:

Remove the merged cells?????

Muddled wrote:

When I try to alhabetize aan excell sheet I am working on, it says all merged
cells must be the same size. How is this overcome?

DG
--

--

Dave Peterson

Excell Alphabetizing & Sorting
 

As a follow-up...........

Merged cells cause no end of problems and are best avoided.

For presentation purposes you can use Center Across Selection which won't
involve merging.

You can also take a picture of the area and superimpose it over a range.

If you use the Camera Tool found under ToolsCustomizeCommands you can take a
picture that will update as cell contents are altered.


Gord

On Sat, 19 May 2007 21:19:55 -0700, Gord Dibben <gorddibbATshawDOTca wrote:

You have done it before?

Yes...........if all the merged cells in the sort range were the same size.


Gord Dibben MS Excel MVP

On Sat, 19 May 2007 19:29:01 -0700, Muddled
wrote:

iI suppose that would work, Except that it would mean completely remaking my
sheet. Also I Know I have done this before-- Just don't recall how.
DG
-


"Dave Peterson" wrote:

Remove the merged cells?????

Muddled wrote:

When I try to alhabetize aan excell sheet I am working on, it says all merged
cells must be the same size. How is this overcome?

DG
--

--

Dave Peterson