I am using google sheets, for a client. There are some rows hidden. I can not unhide them. If I hide some rows myself, then I get a little updown arrow, that I can click to unhide them. However this is not present on the ones that are already hidden.

Is there another way that they could be hidden, that I can investigate?

  • Are you using Excel also, or just Google Spreadsheets? Commented May 25, 2018 at 15:04
  • @music2myear I am not using Excel, gnumeric, kspread, libreoffice calc, star office, lotus 123, … just google sheets. Commented Oct 27, 2020 at 13:37

2 Answers 2


It was filters. I turned them off.

Go to Menu → Data → filters, you can turn them off, you may want to adjust them some other way.


I had a similar, but different, problem: I had narrowed the column to the point where I could not see anything in the column and I could not grab it and make it wider. (hope this is useful for people that search for this.)


Highlight the column to the left or right of the column you can not see the data in, then highlight the column you can not see the data in and then right click and Resize.

Now you can see both columns. This only took me 30 minutes to figure out, hope it helps.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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