Is This Possible?

[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

 

[Eamon]

Sorry should read seven Colums

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

Sorry should read seven Colums

 

[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

 

[Eamon]

Chip,

Thanks for your reply.

Regards,
Eamon

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

 

[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