[Solved] How Do I Find, Highlight, and Copy...
Posted: Fri May 22, 2020 6:40 pm
Hello,
I've got a spreadsheet that I'm sort of using primarily as just an organizational list right now. No real calculations going on.
On one particular sheet I used the search function to highlight a specific word everywhere it occurs on that sheet to make highlighting each row it occurs easier. I went through and Ctrl+left clicked each row and once I got to the end, I tried copying, however it gives me an error saying the function won't work on multiple selections.
Prior to using the search function to make it easier than having to read everything in the sheet, I went through line by line and did just that, but still used Ctrl+left click to highlight entire rows of information before copy and pasting into a new sheet. It worked that way, so I'm guessing something about utilizing the search function is somehow messing it up now, but I can't figure out why, or if there's any way to save the time of having to go through and read all 700 or so rows of text over again.
If I'm not explaining this well enough please let me know.
I've got a spreadsheet that I'm sort of using primarily as just an organizational list right now. No real calculations going on.
On one particular sheet I used the search function to highlight a specific word everywhere it occurs on that sheet to make highlighting each row it occurs easier. I went through and Ctrl+left clicked each row and once I got to the end, I tried copying, however it gives me an error saying the function won't work on multiple selections.
Prior to using the search function to make it easier than having to read everything in the sheet, I went through line by line and did just that, but still used Ctrl+left click to highlight entire rows of information before copy and pasting into a new sheet. It worked that way, so I'm guessing something about utilizing the search function is somehow messing it up now, but I can't figure out why, or if there's any way to save the time of having to go through and read all 700 or so rows of text over again.
If I'm not explaining this well enough please let me know.