Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Filters
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Filters
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Filters | Excel Discussion (Misc queries) | |||
Excel Filters | Excel Discussion (Misc queries) | |||
Filters, Subtotal & Intacted Results after the filters' Removal | Excel Discussion (Misc queries) | |||
Filters in excel | Excel Worksheet Functions | |||
Filters in Excel | Excel Discussion (Misc queries) |