About 1,797,767 results (5,974 milliseconds)
How to hide columns on multiple sheets in a workbook - Google ...
https://support.google.com/docs/thread/119851005/how-to-hide-columns-on-multiple-sheets-in-a-workbook?hl=en Aug 4, 2021 ... Shows and hides columns across multiple sheets as the user shows and hides them in a master sheet. Works with column grouping and regular column show/hide ...
How can I hide one or several columns from our viewer while my ...
https://support.google.com/docs/thread/72402666/how-can-i-hide-one-or-several-columns-from-our-viewer-while-my-editor-can-see-it?hl=en 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 ...
google apps script to hide a google sheets tab from specific users ...
https://support.google.com/docs/thread/161101072/google-apps-script-to-hide-a-google-sheets-tab-from-specific-users?hl=en Apr 24, 2022 ... I found a script that should solve my issue of hiding a specific tab (ideally multiple tabs if necessary)
Hide Columns Based on User Selection - Google Docs Editors ...
https://support.google.com/docs/thread/162147555/hide-columns-based-on-user-selection?hl=en May 3, 2022 ... I have a Google Sheet that I am looking to automatically hide columns on using a script (based on the selection of a data validation drop down list).
Different password for different worksheet
https://groups.google.com/g/microsoft.public.excel.worksheet.functions/c/c_-kGU3JQTQ Keeping in mind that internal security is very weak in Excel. Requires VBA code and some passwords or login names. Sample code................
Only Copy and Paste VISIBLE cells in Google Sheets - Google Docs ...
https://support.google.com/docs/thread/38767079/only-copy-and-paste-visible-cells-in-google-sheets?hl=en Apr 8, 2020 ... When I copy the the rows into a different sheet, it also pastes all the hidden rows.
Building excel application instead of add-in
https://groups.google.com/g/exceldna/c/7cXv_NTnPuk Currently I have an excel app (with template spreadsheets, and rich VBA ... I also remove all unnecessary extra tabs so the user can only do what I want ...
Google Sheets/Google Apps Script Functionality vs Excel/VBA ...
https://groups.google.com/g/google-apps-script-community/c/kXI344eEd9c There's obviously the button to show/hide the key color legend as well, but that seems trivial compared to the rest of the project's programming. Could anyone ...
How to remove data validation for selected cells - Google Docs ...
https://support.google.com/docs/thread/193872200/how-to-remove-data-validation-for-selected-cells?hl=en Dec 21, 2022 ... ... spreadsheet, not just the selected cells. How do I remove data validation for selected cells only. Details. Sheets,Microsoft Windows,Personal ...
code to unhide tabs based on cell contents
https://groups.google.com/g/microsoft.public.excel.worksheet.functions/c/yZ1TWo_nJb0 I want to do is hide all the tabs except a contents tab and be able to unhide specific tabs based on which cell someone clicks in.
This has to be simple, but how do I turn off insert, or overwrite of text ...
https://support.google.com/docs/thread/3653333/this-has-to-be-simple-but-how-do-i-turn-off-insert-or-overwrite-of-text-in-cells?hl=en Apr 5, 2019 ... What a stupid problem for Google Sheets to have. If NONE of the above steps help to resolve the issue for you, it may be helpful to ...
extra decimal places appearing in sum when contained in larger text ...
https://support.google.com/docs/thread/230938671/extra-decimal-places-appearing-in-sum-when-contained-in-larger-text?hl=en Aug 18, 2023 ... Any ideas? (I know I could use a function like round to just hide ... Spreadsheet programs such as Google Sheets, Microsoft Excel, Apache ...
can you expand all groups & collapse all groups in sheets (ie by ...
https://support.google.com/docs/thread/14506517/can-you-expand-all-groups-collapse-all-groups-in-sheets-ie-by-group-hierachy-level-like-in-excel?hl=en Sep 16, 2019 ... As far as I can tell grouping (currently) is only a method for hiding/unhiding groups of cells. No other group qualities.
How do I delete recurring events from a calendar which was shared ...
https://support.google.com/calendar/thread/189740928/how-do-i-delete-recurring-events-from-a-calendar-which-was-shared-with-me?hl=en Nov 22, 2022 ... Since these are in my calendar every single day, it causes quite a bit of clutter. These events are in the same calendar as school events or ...
"Marching ants" around copied cell
https://groups.google.com/g/microsoft.public.excel.newusers/c/gJg5od8dlNk Close the window and return to Excel. Goto the menu Window>Hide. This will ... Wait a minute or two and restart Excel. Now, create a toolbar button. Right ...
Array formula range importing empty cells - Google Docs Editors ...
https://support.google.com/docs/thread/236841903/array-formula-range-importing-empty-cells?hl=en Sep 28, 2023 ... I am looking to move all highlighted items to a sheet on another page under the heading 'special order'. I've tried the formula =ARRAYFORMULA(IF('sheet1'!H15: ...
Generate PDF and attach Email - School Reports
https://groups.google.com/g/google-apps-script-community/c/e0B7-eOoa8g Dec 15, 2021 ... I assume this is possible because I was able to get it done in Microsoft Excel via VBA... ... Are the spreadsheets different files or different ...
creating the numbering sequence 1.1, 1.2, 1.3, 2.1, 2.2, 2.3 and so ...
https://groups.google.com/g/microsoft.public.word.numbering/c/kSC3RsaljTc so on. How do I start from 1.1 instead, i.e. 1.1 is my "level 1"? I know fields or VBA can help exorcise all these Word demons ...
Script to automatically add checkboxes to a non-empty row - Google ...
https://support.google.com/docs/thread/126916173/script-to-automatically-add-checkboxes-to-a-non-empty-row?hl=en Sep 20, 2021 ... Sheets,Chrome OS,Personal use. Locked. This question is locked and ... hide the checkboxes (make background color and text color white so ...
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 ... You can use VBA (record macros etc) but that means if someone ...