ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   how to identically size merged cells for filtering use (https://www.excelbanter.com/excel-worksheet-functions/79402-how-identically-size-merged-cells-filtering-use.html)

SherryRO

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

Marijus

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


All times are GMT +1. The time now is 07:11 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com