G Guest May 20, 2007 #1 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 --
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 --
D Dave Peterson May 20, 2007 #2 Remove the merged cells????? 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 -- Click to expand...
Remove the merged cells????? 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 -- Click to expand...
G Guest May 20, 2007 #3 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 -
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 -
G Gord Dibben May 20, 2007 #4 You have done it before? Yes...........if all the merged cells in the sort range were the same size. Gord Dibben MS Excel MVP
You have done it before? Yes...........if all the merged cells in the sort range were the same size. Gord Dibben MS Excel MVP
G Gord Dibben May 20, 2007 #5 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 Tools>Customize>Commands you can take a picture that will update as cell contents are altered. Gord
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 Tools>Customize>Commands you can take a picture that will update as cell contents are altered. Gord
