LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Joe Joe is offline
external usenet poster
 
Posts: 38
Default how can I filter a worksheet to only show cells with certain terms in them?

I'd like to filter an entire worksheet to only show me cells with a
certain term. For example "Apple Computer". I know I can do this by
column but I'd like to be able to do this over multiple columns. Does
Excel have a function for this?

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
When in filter mode status bar doesn't show range of cells filted Marie McNamee Excel Worksheet Functions 1 November 20th 06 03:18 PM
How do I filter columns of merged cells to show all related rows? mosaic Excel Discussion (Misc queries) 2 July 5th 06 10:09 AM
FILTER: show/don't show selection with tickboxes ancharwashere Excel Discussion (Misc queries) 2 October 11th 05 09:20 PM
I want to show all comments on cells in one cell in the worksheet Claire Excel Worksheet Functions 1 June 17th 05 09:47 AM
How do I show protected cells in an EXCEL worksheet laurentdada Excel Discussion (Misc queries) 3 April 19th 05 01:45 PM


All times are GMT +1. The time now is 10:56 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"