You could apply Data|Filter|Autofilter to that column.

Then use the dropdown arrow, choose X from the adjecent dropdown
To see what you want.

Then data|Filter|Show all
to see everything.

Ed wrote:
>
> Hello, I have a table which has main activities and subactivities. Main
> activities are the total of the subactivities and are diferentiated with a
> "x" in a specific column... how can I manage, I guess i will need a Macro or
> something, to automatically Hide all the Rows not containing that "x" so in
> that way I can easily have the summary of all instead of manually hiding and
> unhiding rows?

--

Dave Peterson