ExcelBanter - Excel Filters

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Excel Filters (https://www.excelbanter.com/excel-discussion-misc-queries/200081-excel-filters.html)

Hi there. Hoping an Excel guru out there can help me!

I have an excel spreadsheet with filters applied. I have cells in
spreadsheet that are both merged and unmerged. When I filter by column A
(merged cell), it only picks up one line of data. I lose other data that is
not associated with merged cell.

Is there any way around this?

Thanks!
Josie

Merging multiple cells to one create a larger single cell which Excel treats
as such.

Unmerge the cells.

They cause no end of problems, one of which you are seeing.

Gord Dibben MS Excel MVP

On Mon, 25 Aug 2008 08:28:01 -0700, Josie
wrote:

Hi there. Hoping an Excel guru out there can help me!

I have an excel spreadsheet with filters applied. I have cells in
spreadsheet that are both merged and unmerged. When I filter by column A
(merged cell), it only picks up one line of data. I lose other data that is
not associated with merged cell.

Is there any way around this?

Thanks!
Josie