2

When I search the current sheet using Ctrl+F in a Google Sheet, hidden rows aren't searched.

I know I can manually unhide all the hidden rows and then do the search, but then I would have to remember which ones were hidden and hide them again, which is annoying. Also, if I was sharing the spreadsheet with others, they would see the rows being unhidden and then hidden again, which is not necessarily ideal.

2

Copy the spreadsheet, or a selected area of it, and paste it into a new spreadsheet. Highlight the rows or columns you want to search, right-.click and choose Unhide. Do your search, and then delete the copy.

There should be an easier way! But this is the best I know of.

1

Another way to do it is to unhide the selection, then do the search but make sure not to make any changes or do anything else. When you finish the search, simply undo (ctl + z or command + z for mac) and this should rehide the selection without you needing to remember exactly which rows were selected. It worked well for me :)

0

Go to File -> Download as -> Comma-separated values in the menus (the Google Sheets menus, not the web browser's menus!). Whichever platform you are on, you will definitely be able to find some free software or web application that will open .csv files. For example, you can open them in a text editor and use the text editor's Find functionality, or just use grep on Linux, or even import them back into a new Google Spreadsheet.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.