Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to identically size merged cells for filtering use
I'm trying to filter a column in Excel. I've added an auto filter to the
column, but when I hit the arrow to filter alphabetically ascending, it quotes "This operation requires the mergec cells to be identically sized." But it doesn't tell me how to do it and I've not found it on the website,,, Please help! Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to identically size merged cells for filtering use
When you use filter or sorter in excel NO CELLS CAN BE MERGE in list.
So unmerge celss in the list and try again. -- M.A. "SherryRO" wrote in message ... I'm trying to filter a column in Excel. I've added an auto filter to the column, but when I hit the arrow to filter alphabetically ascending, it quotes "This operation requires the mergec cells to be identically sized." But it doesn't tell me how to do it and I've not found it on the website,,, Please help! Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Blank Rows from Merged Cells in Drop Down Menu | Excel Discussion (Misc queries) | |||
Errors in COUNT, COUNTA, COUNTIF when counting merged cells | Excel Worksheet Functions | |||
Chart data from merged cells. | Excel Discussion (Misc queries) | |||
getting msg: cannot sort merged cells not same size | Excel Discussion (Misc queries) | |||
Pasting into merged cells | Excel Discussion (Misc queries) |