PC Review


Reply
Thread Tools Rate Thread

(auto)filter on row

 
 
=?Utf-8?B?Qm9nZGFu?=
Guest
Posts: n/a
 
      16th Jul 2007
Is there any posibility to create an autofilter on row (instead of columns)?

Many thanks,

Bogdan
 
Reply With Quote
 
 
 
 
Dave Peterson
Guest
Posts: n/a
 
      16th Jul 2007
Not quite the same, but you can group columns.

Select a few columns
(in xl2003)
data|Group and outline|Group



Bogdan wrote:
>
> Is there any posibility to create an autofilter on row (instead of columns)?
>
> Many thanks,
>
> Bogdan


--

Dave Peterson
 
Reply With Quote
 
Dave Peterson
Guest
Posts: n/a
 
      16th Jul 2007
You may want to define different views, too.

In xl2003, hide the columns you want.
View|custom views|add (a new view)

Include a view that unhides everything to make it easy.

===
Another option would be to use a macro to hide columns that you don't want to
see.

Dave Peterson wrote:
>
> Not quite the same, but you can group columns.
>
> Select a few columns
> (in xl2003)
> data|Group and outline|Group
>
> Bogdan wrote:
> >
> > Is there any posibility to create an autofilter on row (instead of columns)?
> >
> > Many thanks,
> >
> > Bogdan

>
> --
>
> Dave Peterson


--

Dave Peterson
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto Filter - Custom Auto Filter Johnnyboy5 Microsoft Excel Programming 4 2nd Aug 2009 09:36 AM
Data>Filter>Auto Filter in excel 2007? TIJ Microsoft Excel New Users 2 13th Nov 2008 03:28 AM
Excel 2007 Auto Filter Filter Django Microsoft Excel Misc 2 9th Sep 2008 10:52 PM
Limit filter options in Auto Filter lista72 Microsoft Excel Misc 1 23rd Jan 2008 04:01 PM
Excel auto filter doesn't recoginize case - won't filter AA from A =?Utf-8?B?TWlrZXk=?= Microsoft Excel Misc 1 29th Sep 2005 08:18 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:32 PM.