Google Sheets – How to Unhide Rows in Google Sheets

google sheets

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?

Best Answer

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.

Related Solutions

Google Sheets – Print Filtered Rows

Create yet another sheet, with a catchy name like for example PRINTING.

Use the FILTER formula to set the data range and filter for the sub-contractor:

=FILTER(DATA!A:U, DATA!F:F=H1)   // H1 = Xzila

If you place H1 outside the printing area, then it will not take part in the printing.

Google Sheets Query for Non-Empty Cells

Please try:

=QUERY('Form Responses 1'!A:N,"SELECT C,E,G,H where G is not null or H is not null order by C,E")

Best Answer

Related Solutions

Google Sheets – Print Filtered Rows

Google Sheets Query for Non-Empty Cells

Related Topic