About 1,610,049 results (5,625 milliseconds)
Is it possible to sort Google sheets if it has protected ranges in it ...
https://support.google.com/docs/thread/10084409/is-it-possible-to-sort-google-sheets-if-it-has-protected-ranges-in-it?hl=en Jul 17, 2019 ... I know that in excel you can filter options on a protected sheet. Is ... Filter views do not appear if any portion of the sheet is protected.
Sort and Filter with protected cells. No Filter View! - Google Docs ...
https://support.google.com/docs/thread/75804143/sort-and-filter-with-protected-cells-no-filter-view?hl=en Oct 9, 2020 ... ... not that Excel/Google sheets savvy, to put it mildly. You see, Google, not all of the people who use Google sheets know what they are doing.
How do I keep a cell protected during a sort? - Google Docs Editors ...
https://support.google.com/docs/thread/10622718/how-do-i-keep-a-cell-protected-during-a-sort?hl=en Jul 25, 2019 ... I am fairly new with sheets and have changed from excel, which had not problem protecting but did not allow real time sharing. I am hoping there ...
Protected Cells Not Working - Google Docs Editors Community
https://support.google.com/docs/thread/34011564/protected-cells-not-working?hl=en Mar 17, 2020 ... I am trying to protect various cells in Google Sheets. I select the cells I want to protect, click DATA > PROTECTED SHEETS & RANGES and the tool bar on the ...
Hi, how to allow to do like filters when I have protected a column of a ...
https://support.google.com/docs/thread/13173360/hi-how-to-allow-to-do-like-filters-when-i-have-protected-a-column-of-a-spreadsheet?hl=en Aug 30, 2019 ... You can create filters on partially protected sheets. If you want users to be able to change a filter, then that area of the sheet must be unprotected.
Can you protect cells without impacting filter views? - Google Docs ...
https://support.google.com/docs/thread/109278573/can-you-protect-cells-without-impacting-filter-views?hl=en May 9, 2021 ... Community content may not be verified or up-to-date. ... See the Filter views example spreadsheet for proof that filter views work fine in a ...
Google Sheets: Column filter not working - Google Docs Editors ...
https://support.google.com/docs/thread/3082766/google-sheets-column-filter-not-working?hl=en Mar 26, 2019 ... How can users use the filter option with the protected range or sheets??? ... working fine in Excel and now is not. I can't rebuild this sheet ...
"Exception: You are trying to edit a protected cell or object." on ...
https://support.google.com/docs/thread/108177286/exception-you-are-trying-to-edit-a-protected-cell-or-object-on-unprotected-cell-with-script?hl=en Apr 30, 2021 ... I did some more testing. It seems its a problem specifically tied to that account. I clone the sheet under their account and ran the script on ...
"protected sheets and ranges" not showing up as an option under ...
https://support.google.com/docs/thread/102247799/protected-sheets-and-ranges-not-showing-up-as-an-option-under-data-in-my-google-sheet?hl=en Mar 14, 2021 ... You're editing an Excel doc! Yes? No idea, but apparently, the feature is not supported when editing Excel. That explains it I think! Lance.
Security with importrange - Google Docs Editors Community
https://support.google.com/docs/thread/27860556/security-with-importrange?hl=en Feb 6, 2020 ... ... filter part and use ... The other thing you can do is protect the sheet so that edits cannot not be made with the IMPORTRANGE formulas.
How to share sheets with Multiple people but they can see only what ...
https://support.google.com/docs/thread/54402092/how-to-share-sheets-with-multiple-people-but-they-can-see-only-what-they-require-to?hl=en Jun 20, 2020 ... I'm not an expert but I have a similar issue I'm working on. You can ... Then filter to another sheet by department name (Note filter ...
Protect sheet, but allow slicers. - Google Docs Editors Community
https://support.google.com/docs/thread/112696745/protect-sheet-but-allow-slicers?hl=en Jun 7, 2021 ... I am not sure why they restrict you from using them on a protected sheet though. A way around that might be to use a Filter View instead.
'Create a filter' is gone from my Data menu! - Google Docs Editors ...
https://support.google.com/docs/thread/85321369/create-a-filter-is-gone-from-my-data-menu?hl=en Nov 25, 2020 ... Perhaps the sheet contains a protected range that prevents filtering? ... I find that creating a filter view is a bit clunky and not suitable for ...
Make shared Sheet's column size and other formating options local ...
https://support.google.com/docs/thread/64863790/make-shared-sheet-s-column-size-and-other-formating-options-local?hl=en Aug 14, 2020 ... I have a shared sheet with multiple people editing it regurlaly. The problem is that whenever someone changes the size of a column or edit any formating option ...
Sheets Filter not working correctly - Google Docs Editors Community
https://support.google.com/docs/thread/13200579/sheets-filter-not-working-correctly?hl=en Aug 30, 2019 ... Sheets Filter not working correctly ... We have a spreadsheet with some filters and conditional formatting in different columns. The cells in ...
Protected cells in Sheets doc - Google Docs Editors Community
https://support.google.com/docs/thread/6427737/protected-cells-in-sheets-doc?hl=en May 19, 2019 ... I think that you're not seeing the menu item because you are directly editing your Excel sheet. ... work in xlsx because of other formula ...
Shared users cannot use filters where needed - Google Docs ...
https://support.google.com/docs/thread/209650817/shared-users-cannot-use-filters-where-needed?hl=en Apr 5, 2023 ... The problem is the warning (You're trying to edit part of this sheet that shouldn't be changed accidentally. Edit anyway?) comes up every time ...
Reference Named range for unprotected ranges in protected sheet ...
https://support.google.com/docs/thread/86531816/reference-named-range-for-unprotected-ranges-in-protected-sheet?hl=en Dec 2, 2020 ... ... not when specifying "except certain cells" when protecting a sheet. ... spreadsheet functions such as sort() , query() and filter() . You ...
Sheets can't make filter (removed filters and filterviews) - Google ...
https://support.google.com/docs/thread/212058558/sheets-can-t-make-filter-removed-filters-and-filterviews?hl=en Apr 20, 2023 ... This document has many sheets and only one sheet has that problem. Any help is welcome! Details. Sheets,Microsoft Windows,Business. Locked.
How to lock a row to move with a filter on a column - Google Docs ...
https://support.google.com/docs/thread/139208234/how-to-lock-a-row-to-move-with-a-filter-on-a-column?hl=en Dec 7, 2021 ... I am trying to design an orders sheet for myself. I am a recent transfer from excel and I am having trouble figuring out how to get a row to ...