Hello,
I was wondering if there is a way to search a certain word that is in one cell and then select the entire rows that that cell is in.
For instance, I want to be able to select a group of rows all at once that one word shows up in and copy and paste only those rows to a new spreadsheet. Is it possible to do that just by searching the word in one cell of the row?
Thank you.
It’s possible using filters, with the Standard filter or the Advanced filter you can send the filtered rows to a different sheet, so it’s easy to copy that sheet to another file.
can send the filtered rows to a different sheet.
by expanding “Options” within the respective dialog.
@mariosv - sorry for this comment, but I missed that great functionality for years due to never expanding the “Options”.
Thank you so much for your help. I’m new to the program.
Then the better you can do for yourself it’s take a quick review of the help, not to let everhing but to have an idea about the capabilities of the program, so it easy to find them when they are neede.