Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sort alpa descending 'cell size' error
I have a simple address book worksheet (last name, salutation, address,
telephone) All cells are formatted as TEXT having numbers and letters cells vary in size, but all have same font, some have auto wrap, some manual indents, some columns are wider than others when I try to sort by 'last name'/'first name' I get pop-up window message: "The operation requires merged cells to be identically sized." I have tried to both protect and not protect the cells. I have assured no hidden columns or rows are included. I know the cells are not identical, but they are under each column as far as width. ANY IDEAS!? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sort alpa descending 'cell size' error
Could be some of your Header cells are merged, such as a Title, etc.....
Vaya con Dios, Chuck, CABGx3 "clubfisher" wrote: I have a simple address book worksheet (last name, salutation, address, telephone) All cells are formatted as TEXT having numbers and letters cells vary in size, but all have same font, some have auto wrap, some manual indents, some columns are wider than others when I try to sort by 'last name'/'first name' I get pop-up window message: "The operation requires merged cells to be identically sized." I have tried to both protect and not protect the cells. I have assured no hidden columns or rows are included. I know the cells are not identical, but they are under each column as far as width. ANY IDEAS!? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sort alpa descending 'cell size' error
Select the whole worksheet, and unmerge the cells.
"clubfisher" wrote in message ... I have a simple address book worksheet (last name, salutation, address, telephone) All cells are formatted as TEXT having numbers and letters cells vary in size, but all have same font, some have auto wrap, some manual indents, some columns are wider than others when I try to sort by 'last name'/'first name' I get pop-up window message: "The operation requires merged cells to be identically sized." I have tried to both protect and not protect the cells. I have assured no hidden columns or rows are included. I know the cells are not identical, but they are under each column as far as width. ANY IDEAS!? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sort alpa descending 'cell size' error
hi,
try to select the range, click in Format menu, format cell, align and uncheck the merge cell box hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "clubfisher" escreveu: I have a simple address book worksheet (last name, salutation, address, telephone) All cells are formatted as TEXT having numbers and letters cells vary in size, but all have same font, some have auto wrap, some manual indents, some columns are wider than others when I try to sort by 'last name'/'first name' I get pop-up window message: "The operation requires merged cells to be identically sized." I have tried to both protect and not protect the cells. I have assured no hidden columns or rows are included. I know the cells are not identical, but they are under each column as far as width. ANY IDEAS!? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sort alpa descending 'cell size' error
"clubfisher" wrote in message
... I have a simple address book worksheet (last name, salutation, address, telephone) All cells are formatted as TEXT having numbers and letters cells vary in size, but all have same font, some have auto wrap, some manual indents, some columns are wider than others when I try to sort by 'last name'/'first name' I get pop-up window message: "The operation requires merged cells to be identically sized." I have tried to both protect and not protect the cells. I have assured no hidden columns or rows are included. I know the cells are not identical, but they are under each column as far as width. ANY IDEAS!? The answer is: Don't merge cells. If you are lucky you may find that the only cells merged are in a header, so if you select the actual data rows you may be lucky & be able to sort them. Otherwise you'll have to split the merged cells. -- David Biddulph |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
Cell size? Or size limit for Text data type? | Excel Discussion (Misc queries) | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
Excel Sort function should not sort the cell formatting! | Excel Worksheet Functions |