software

I need to use the Autofilter on the first column of data. However, each cell
in the first column is actually two cells (two rows merged), and it is not
filtering properly. e.g.

1962 Jane Doe 13 15 27
Hired xxxx 4 7 10
1974 John Smith 27 15 30
Hired xxxx 12 7 10

As you can see, there are two rows of data for each entry in the first
column. When I use Autofilter I only get the top line of data. How can I
change it so I get both rows of data when filtering on the first column?Don't use merged cells, I know of nobody that are beyond beginner that use
merged cells, it will (almost) always cause problems down the line and you
can get almost identical layout using other tricks. Since I never use merged
cells (if I work on a sheet that originally had them I take them off and fix
them) I don't know an answer except removing them and use for instance alt
enter for multiple lines in the same cell, center across selection to spread
text evenly over multiple cells--

Regards,

Peo Sjoblom

quot;windsongquot; gt; wrote in message
...
gt; I need to use the Autofilter on the first column of data. However, each
cell
gt; in the first column is actually two cells (two rows merged), and it is not
gt; filtering properly. e.g.
gt;
gt; 1962 Jane Doe 13 15 27
gt; Hired xxxx 4 7 10
gt; 1974 John Smith 27 15 30
gt; Hired xxxx 12 7 10
gt;
gt; As you can see, there are two rows of data for each entry in the first
gt; column. When I use Autofilter I only get the top line of data. How can I
gt; change it so I get both rows of data when filtering on the first column?
gt;
Still doesn't fix the problem, though.
quot;Peo Sjoblomquot; wrote:

gt; Don't use merged cells, I know of nobody that are beyond beginner that use
gt; merged cells, it will (almost) always cause problems down the line and you
gt; can get almost identical layout using other tricks. Since I never use merged
gt; cells (if I work on a sheet that originally had them I take them off and fix
gt; them) I don't know an answer except removing them and use for instance alt
gt; enter for multiple lines in the same cell, center across selection to spread
gt; text evenly over multiple cells
gt;
gt;
gt; --
gt;
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; quot;windsongquot; gt; wrote in message
gt; ...
gt; gt; I need to use the Autofilter on the first column of data. However, each
gt; cell
gt; gt; in the first column is actually two cells (two rows merged), and it is not
gt; gt; filtering properly. e.g.
gt; gt;
gt; gt; 1962 Jane Doe 13 15 27
gt; gt; Hired xxxx 4 7 10
gt; gt; 1974 John Smith 27 15 30
gt; gt; Hired xxxx 12 7 10
gt; gt;
gt; gt; As you can see, there are two rows of data for each entry in the first
gt; gt; column. When I use Autofilter I only get the top line of data. How can I
gt; gt; change it so I get both rows of data when filtering on the first column?
gt; gt;
gt;
gt;
gt;

Wind

To keep the rows together you must have duplicate numbers in Column A

After unmerging the cells select column A and F5gt;Specialgt;Blanksgt;OK

In activecell enter an = sign then point to cell above and hit CTRL ENTER.

Copygt;Paste Specialgt;Valuegt;OKgt;Esc

Now filter for 1962 on column A

You will get both rows returned.Gord Dibben Excel MVP

On Tue, 13 Dec 2005 10:39:02 -0800, quot;windsongquot;
gt; wrote:

gt;Still doesn't fix the problem, though.
gt;
gt;
gt;
gt;quot;Peo Sjoblomquot; wrote:
gt;
gt;gt; Don't use merged cells, I know of nobody that are beyond beginner that use
gt;gt; merged cells, it will (almost) always cause problems down the line and you
gt;gt; can get almost identical layout using other tricks. Since I never use merged
gt;gt; cells (if I work on a sheet that originally had them I take them off and fix
gt;gt; them) I don't know an answer except removing them and use for instance alt
gt;gt; enter for multiple lines in the same cell, center across selection to spread
gt;gt; text evenly over multiple cells
gt;gt;
gt;gt;
gt;gt; --
gt;gt;
gt;gt; Regards,
gt;gt;
gt;gt; Peo Sjoblom
gt;gt;
gt;gt; quot;windsongquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; I need to use the Autofilter on the first column of data. However, each
gt;gt; cell
gt;gt; gt; in the first column is actually two cells (two rows merged), and it is not
gt;gt; gt; filtering properly. e.g.
gt;gt; gt;
gt;gt; gt; 1962 Jane Doe 13 15 27
gt;gt; gt; Hired xxxx 4 7 10
gt;gt; gt; 1974 John Smith 27 15 30
gt;gt; gt; Hired xxxx 12 7 10
gt;gt; gt;
gt;gt; gt; As you can see, there are two rows of data for each entry in the first
gt;gt; gt; column. When I use Autofilter I only get the top line of data. How can I
gt;gt; gt; change it so I get both rows of data when filtering on the first column?
gt;gt; gt;
gt;gt;
gt;gt;
gt;gt;

Thank you. This helps a lot.

quot;Gord Dibbenquot; wrote:

gt; Wind
gt;
gt; To keep the rows together you must have duplicate numbers in Column A
gt;
gt; After unmerging the cells select column A and F5gt;Specialgt;Blanksgt;OK
gt;
gt; In activecell enter an = sign then point to cell above and hit CTRL ENTER.
gt;
gt; Copygt;Paste Specialgt;Valuegt;OKgt;Esc
gt;
gt; Now filter for 1962 on column A
gt;
gt; You will get both rows returned.
gt;
gt;
gt; Gord Dibben Excel MVP
gt;
gt; On Tue, 13 Dec 2005 10:39:02 -0800, quot;windsongquot;
gt; gt; wrote:
gt;
gt; gt;Still doesn't fix the problem, though.
gt; gt;
gt; gt;
gt; gt;
gt; gt;quot;Peo Sjoblomquot; wrote:
gt; gt;
gt; gt;gt; Don't use merged cells, I know of nobody that are beyond beginner that use
gt; gt;gt; merged cells, it will (almost) always cause problems down the line and you
gt; gt;gt; can get almost identical layout using other tricks. Since I never use merged
gt; gt;gt; cells (if I work on a sheet that originally had them I take them off and fix
gt; gt;gt; them) I don't know an answer except removing them and use for instance alt
gt; gt;gt; enter for multiple lines in the same cell, center across selection to spread
gt; gt;gt; text evenly over multiple cells
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; --
gt; gt;gt;
gt; gt;gt; Regards,
gt; gt;gt;
gt; gt;gt; Peo Sjoblom
gt; gt;gt;
gt; gt;gt; quot;windsongquot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt; I need to use the Autofilter on the first column of data. However, each
gt; gt;gt; cell
gt; gt;gt; gt; in the first column is actually two cells (two rows merged), and it is not
gt; gt;gt; gt; filtering properly. e.g.
gt; gt;gt; gt;
gt; gt;gt; gt; 1962 Jane Doe 13 15 27
gt; gt;gt; gt; Hired xxxx 4 7 10
gt; gt;gt; gt; 1974 John Smith 27 15 30
gt; gt;gt; gt; Hired xxxx 12 7 10
gt; gt;gt; gt;
gt; gt;gt; gt; As you can see, there are two rows of data for each entry in the first
gt; gt;gt; gt; column. When I use Autofilter I only get the top line of data. How can I
gt; gt;gt; gt; change it so I get both rows of data when filtering on the first column?
gt; gt;gt; gt;
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;