filter on the rows
 

Is there any possibility to make a filter on the rows?


--
shlomop
------------------------------------------------------------------------
shlomop's Profile: http://www.excelforum.com/member.php...fo&userid=9734
View this thread: http://www.excelforum.com/showthread...hreadid=467093

As far as I know, no. Filters can only be applied to columns. You may
need to transpose your data to apply a filter.

I'm sure if someone knows of a way (probably via VBA) they will post a
solution.

Good Luck

Bruce


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=467093

Not really.

But you could play around with Grouping your columns.

You'll see those same kind of +/-'s but at the top.

Select a few columns
data|Group and Outline
Group

(but it's a manual effort--well, unless you came up with rules and make a macro
out of it.)

shlomop wrote:

Is there any possibility to make a filter on the rows?

--
shlomop
------------------------------------------------------------------------
shlomop's Profile: http://www.excelforum.com/member.php...fo&userid=9734
View this thread: http://www.excelforum.com/showthread...hreadid=467093

--

Dave Peterson