About 1,626,064 results (3,057 milliseconds)
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 ... ... 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.
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 ... an iPad or tablet using Google Sheets. When a sheet is protected, the user can click the filter button at the top and choose "Create new ...
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 26, 2019 ... What I found was that - when sorting a column that included protected cells, Sheets automatically opted to use a FILTER VIEW. A FV is a ...
Collaborate in Sheets - Google Docs Editors Help
https://support.google.com/docs/answer/9331169?hl=en Share with specific people or using a link. Share workbook in 2013 version. Excel 2013. Options in 2010 version (protect, ...
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 ... If you are wanting to protect a sheet so that the users can't change data, then you can use IMPORTRANGE on a different file and use a filter on ...
'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? You may want to try creating a filter view instead of using Data ...
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.
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 ... Thanks for the help Lance, i will take a look into Filter Views. As for Protected Sheets and Ranges, i'm already using them, each person ...
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 use Google Sheet to write list of my pending work, I also write ... Then filter to another sheet by department name (Note filter ...
"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 ... An issue has been filed at Editor cannot edit unprotected cells in protected sheet using subsequent calls. Click the star icon ☆ in the top ...
How to allow commenters to filter the spreadsheet just for them ...
https://support.google.com/docs/thread/272508867/how-to-allow-commenters-to-filter-the-spreadsheet-just-for-them?hl=en May 2, 2024 ... Use a Literal Array "={ }" formula on a different sheet/tab to show a copy of the (now protected) source data, then filter the data using your ...
hide/unhide column in protected sheet - Google Docs Editors ...
https://support.google.com/docs/thread/11052850/hide-unhide-column-in-protected-sheet?hl=en Aug 1, 2019 ... You can bring all the data together on your Manager's View sheet using ImportRange() of their data. ... query or filter will pull certain column ...
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??? ... This is a sheet that was imported from Excel so I don't know ...
All users need access to change filters in sheets but it gives an error ...
https://support.google.com/docs/thread/12151804/all-users-need-access-to-change-filters-in-sheets-but-it-gives-an-error?hl=en Aug 16, 2019 ... ... filter view but the data will be protected on the sheet. I created a new sheet called AdamHelp on your file that uses this set-up. I hope ...
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 ... Hello. I have created a spreadsheet using Excel in MS Office 2019 (file type xlsx), and protected certain cells while enabling others to be ...
6. Collaborate in Sheets - Google Docs Editors Help
https://support.google.com/docs/answer/9331169?hl=en-GB Share with specific people or using a link. Share workbook in 2013 version. Excel 2013. Options in 2010 version (protect, allow, track) ...
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 ... I want to be able to protect the sheet apart from the first 3 columns, so shared users can't overwrite the formulas pulling data through, ...
Is there anyway yet to be able to have dropdown lists available for ...
https://support.google.com/docs/thread/81581855/is-there-anyway-yet-to-be-able-to-have-dropdown-lists-available-for-viewers?hl=en Nov 7, 2020 ... View Only users can use Data > Filters, and Data > Filter Views. Per ... take all the respective information from another sheet and paste it there ...
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 ... ... spreadsheet functions such as sort() , query() and filter() . You may also want to take a look at tools like Doctopus, Flubaroo and Google ...
what happened to protect sheets option in google sheets - Google ...
https://support.google.com/docs/thread/6535513/what-happened-to-protect-sheets-option-in-google-sheets?hl=en May 21, 2019 ... This appears to be a way to keep the Excel sheet as more of an Excel sheet but still editable. If you take the tour that shows up with the ...