Auto filter on specific columns

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

chicaboo@officeformac.com - 30 Apr 2008 17:18 GMT

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel

Does anyone know how to have the autofilter not affecting a specific column? i have an excel sheet that has autofilters on most of the columns but i need to manually enter text into a new column added.

Reply to this Message

Bob Greenblatt - 30 Apr 2008 19:54 GMT

On 4/30/08 12:18 PM, in article ee9a204.-1@webcrossing.caR9absDaxw,

> Version: 2008
> Operating System: Mac OS X 10.5 (Leopard)
[quoted text clipped - 3 lines]
> have an excel sheet that has autofilters on most of the columns but i need to
> manually enter text into a new column added.

AutoFilter just hides certain rows. You can easily turn it off from the
tools menu. To add data in adjacent columns, just enter it.

Signature

Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom

Reply to this Message

chicaboo@officeformac.com - 01 May 2008 10:44 GMT

That's the thing it won't turn off in the tools menu!!! and it won't let me manually enter text it gives me an error message.

I eventually found a way around it on my PC at home.

Thanks anyway!

Reply to this Message

JE McGimpsey - 01 May 2008 14:46 GMT

> That's the thing it won't turn off in the tools menu!!!

It *should* turn off in the Data/Filter menu.

> and it won't let me
> manually enter text it gives me an error message.

What error message?

Reply to this Message

Mac Forum / Applications / Excel / May 2008

Auto filter on specific columns