|
|
#1
04-03-2017, 02:43 AM
|
||||
|
||||
Only display rows containing a keyword?
Let's assume I have a spreadsheet with 10 columns and 10 rows.
Let's then assume 5 of the rows contain the word 'Hello', though the word is in different columns on each row. Is it possible to hide all rows that do not contain the word 'Hello' anywhere within a row? 
|
|
#2
04-03-2017, 04:48 AM
|
||||
|
||||
Hello
one of many possibilities https://stackoverflow.com/questions/...-in-any-column
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
|
|
#3
04-07-2017, 12:06 AM
|
||||
|
||||
|
Cross-posted at:
https://www.mrexcel.com/forum/excel-...ml#post4793959 https://www.excelforum.com/excel-gen...ml#post4620458 https://www.neowin.net/forum/topic/1...ing-a-keyword/ For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184 Please also read: Excel Forum's Cross-Posting policy in rule #8: http://www.excelforum.com/forum-rule...rum-rules.html Mr Excel's policy on Cross-Posting in rule #13: http://www.mrexcel.com/forum/board-a...rum-rules.html
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word]
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Finding the graphics and inserting the keyword
|
Ajay2506 | Word VBA | 4 | 06-28-2016 05:34 AM |
|
Summarize keyword into word document
|
simba24d | Word | 3 | 06-10-2016 02:28 PM |
|
Multiple keyword search in WORD
|
tvincent8118 | Word VBA | 1 | 06-23-2015 04:45 AM |
| VBA find keyword and move to location then add symbol | Jmanville | Word VBA | 3 | 10-22-2014 01:45 AM |
| Excel Pivot - Do not display rows with zero value | patidallas22 | Excel | 1 | 03-08-2013 01:35 PM |
Windows 8 
Office 2013
Linear Mode
