LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
John Chaffey
 
Posts: n/a
Default Is thr way in Excel to "find" all cells tht cntain spcfic value, .

Sorry about the spelling... had to make it fit.

I want to do what "edit - find" does, except print the resulting rows that
contain the cells it finds. Is there a way to do this? i.e., search for all
rows with "hello" in a cell in column "greeting", say, then hide all the
other rows except these.

Thank you for your time on 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
Excel cannot shift nonblank cells Mr. Maz. Excel Discussion (Misc queries) 2 March 17th 05 11:10 PM
Trace ALL dependent cells in any worksheet anywhere in Excel Graham Tapper Excel Worksheet Functions 6 March 11th 05 05:44 PM
Using the Find tool in EXCEL TK Excel Worksheet Functions 2 February 11th 05 07:51 PM
Excel has a "Find Next" command but no "Find Previous" command. Michael Fitzpatrick Excel Discussion (Misc queries) 2 January 10th 05 11:45 PM
How do I password protect cells in a spreadsheet created in Excel Tbenson37303 Excel Worksheet Functions 0 November 22nd 04 09:21 PM


All times are GMT +1. The time now is 11:13 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"