Is This Possible?

E

Eamon

Hi,

I have a worksheet with six Columns
A B C D E F G

What I want to do is apply a filter to Column F i.e. non-blanks but I want
to keep all data in Column G visible.

Any suggestions will be much appreciated

Regards,

Eamon
 
E

Eamon

Sorry should read seven Colums


Eamon said:
Hi,

I have a worksheet with six Columns
A B C D E F G

What I want to do is apply a filter to Column F i.e. non-blanks but I want
to keep all data in Column G visible.

Any suggestions will be much appreciated

Regards,

Eamon
Click to expand...
Sorry should read seven Colums
 
C

Chip Pearson

Eamon,

No, you can't do this. Filters always hide or show entire rows.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
E

Eamon

Chip,

Thanks for your reply.

Regards,
Eamon

Chip Pearson said:
Eamon,

No, you can't do this. Filters always hide or show entire rows.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
Click to expand...
 
P

Peo Sjoblom

No it is not possible using a filter, when you filter, the whole row will be
hidden

--
For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom
 
Top