Jul 18, 2019 ... The simplest way is just to download that file in excel format and open it then unhide rows you want. ... You need to remove all custom column ...

Sep 9, 2019 ... Consider resizing. I've tried adjusting column size, zoom size, hide columns, etc. No matter. I ...

Mar 12, 2019 ... I've made good use of the Filter Views, but these only hide info within the column - not the whole columns themselves. What solution would you ...

Jan 5, 2022 ... For faster ways of hiding rows, see Batch Hiding Function in Google Script and Hide or Show multiple columns in one command. Some of the ...

Apr 29, 2019 ... Also, I added a column with checkboxes hoping perhaps I could create a function that hides all checked rows...is this possible, and if so how?

Apr 5, 2019 ... Select all your rows right click resize row s - fit data and yes - if rows have been re-sized manual this is cause.

... rows or columns. On your computer, open a spreadsheet in Google Sheets. Select a row or column you want to freeze or unfreeze. At the top, click View and ...

Sep 21, 2020 ... I need to hide some columns in my google sheet for some user(viewer) only. I have some editors and only they can have access to all the data ...

Mar 9, 2021 ... All of the unused columns and rows were hidden, just to make the EXCEL Sheet look more tidy and clean. But for some weird reason, that was ...

May 13, 2019 ... Sheets does not remember where you left off. It will always open to the top left visible cell. So, if you hide a number of rows, that will reduce scrolling.

Mar 17, 2021 ... ... display on one row, automatically expanding the row height to show all text. This is very commonly used for header rows, to allow column ...

Mar 12, 2020 ... I tried making a copy but that allowed the person to change all the cells which is also not what I'm hoping for. Does google sheets have this ...

Apr 9, 2019 ... To get the sum of only visible rows in column A: =SUBTOTAL(9,A1:A). Does that work for you? If not, can you share a sample sheet with us ...

Feb 3, 2023 ... You might need to click on each of the little arrows in the data filter row to see which settings are hiding rows. Columns where a filter has ...

Jul 18, 2019 ... Nevermind -- my bad ... a filter in a column was hiding row #2, not the hide a row feature. Sorry, thought I'd update the post in case anyone ...

Apr 8, 2020 ... ... Excel. Google Sheets has been perfect for my work until now. Hope a feature gets added soon. Details. Sheets,Microsoft Windows,Business.

Sep 9, 2019 ... I grouped rows in a spreadsheet and now the users, assigned as editors, can't expand the rows and they are shown an alert that the cells are protected.

Mar 24, 2020 ... ... hide them when they're done doing what they need to. There is no way to block a subset of users from viewing visible data in your spreadsheet.

Oct 4, 2020 ... Hey Elizabeth,. Every formula is very specific with how it refers to other cells on the sheet. On the sample sheet, the Query is in A6 ...

Mar 17, 2023 ... ... column to display properly. But having them as text shouldn't matter here, since they are only to look at, I assume. Original Poster ...