| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 -- |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting a spreadsheet with Excell 2007 | Excel Worksheet Functions | |||
| Sorting in Excell | Excel Worksheet Functions | |||
| Excell should have more data sorting features | Excel Discussion (Misc queries) | |||
| alphabetizing/sorting text within a cell | Excel Discussion (Misc queries) | |||
| sorting (alphabetizing) while keeping data in tact. | Excel Discussion (Misc queries) | |||
Linear Mode
