Forum Discussion
Solved
Filter with line merged
Hello, Under Excel, I would like to filter a table where some lines are merged. The lines are merged by two lines for the first three columns. When I have filter one of the first three columns,...
The technique could be
- copy / paste column you'd like to filter into another one
- unmerge Name column, on ribbon Home -> Find and Select -> Go to Special -> select Blanks
- type =B4
and Ctrl+Enter
- select column where you copy Names, Format Painter
and apply it to Name column
Now you may filter on Name
LE_TOULLEC , this is normal Excel behavior. If cells A2 and A3 are merged, only cell A2 will have the value. You can test this by typing =A2 in B3 and =A3 in B3.
IMHO, merged cells are nothing but trouble. I'd recommend removing them and repeating the items.