8

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?

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

2 Answers 2

Reset to default
10

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.

Improve this answer
3

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.)

Solution:

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.

Improve this answer

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.