About 1,377,671 results (2,166 milliseconds)
How to stop google sheets unlocking cells that had previously been ...
https://support.google.com/docs/thread/23285844/how-to-stop-google-sheets-unlocking-cells-that-had-previously-been-locked-in-excel?hl=en Dec 19, 2019 ... How to stop google sheets unlocking cells that had previously been locked in excel? ... There are a number of cells that contain formulas that I ...
Can I lock certain cells on a Google Sheet? - Google Docs Editors ...
https://support.google.com/docs/thread/3390116/can-i-lock-certain-cells-on-a-google-sheet?hl=en Apr 1, 2019 ... I can get that function with /preview. What is the point of telling folks they can protect certain cells if it is so hard to figure out (if ...
How do I upload an Excel file with protected cells and not lose the ...
https://support.google.com/docs/thread/65571620/how-do-i-upload-an-excel-file-with-protected-cells-and-not-lose-the-protection?hl=en Aug 18, 2020 ... Trying to upload a Excel spreadsheet with locked Cells with formulas behind them. Then there are gray shaded cells that are open that I can ...
Can I lock cells that contain information or formulas? I just want to be ...
https://support.google.com/docs/thread/204582542/can-i-lock-cells-that-contain-information-or-formulas-i-just-want-to-be-able-to-go-to-entry-cells?hl=en Mar 3, 2023 ... Go to Data > Protect Sheets and Ranges. Then in the side menu, +new sheet or range, change it to "sheet", click the box "except certain cells" and plug in your ...
How to Conditionally Lock Cells based on a Drop Down List in ...
https://support.google.com/docs/thread/155241758/how-to-conditionally-lock-cells-based-on-a-drop-down-list-in-another-column?hl=en Mar 16, 2022 ... The formula worked, so I tried to apply the formula to a Data Validation custom formula so I would still be good to input actual values into the ...
Protect cell ranges but allow them to be changed via a formula ...
https://support.google.com/docs/thread/172778174/protect-cell-ranges-but-allow-them-to-be-changed-via-a-formula-relating-to-a-non-protected-cell?hl=en Jul 27, 2022 ... I have rotas with dates (including day of week) in column down the left, which are supposed to be updated simply by changing one cell by entering the week ...
Insert/ delete row in protected worksheet
https://groups.google.com/g/microsoft.public.excel.worksheet.functions/c/c7BZOGJd4Hs just basic knowledge in Excel and won't understand huge formulas that ... If some cells in the row are protected with formulas and others aren't. you ...
Importrange function: a way to keep specific rows together? - Google ...
https://support.google.com/docs/thread/22383612/importrange-function-a-way-to-keep-specific-rows-together?hl=en Dec 10, 2019 ... ... function will keep the data from the static table with each of the rows. ... locked together by the vlookup() function. You have to be ...
I need help adding formulas with Google Apps Script. - Google Docs ...
https://support.google.com/docs/thread/184049281/i-need-help-adding-formulas-with-google-apps-script?hl=en Oct 14, 2022 ... To protect cells from accidental editing by anyone, including yourself, use the Show a warning when editing this range option. I want to use a ...
Security with importrange - Google Docs Editors Community
https://support.google.com/docs/thread/27860556/security-with-importrange?hl=en Feb 6, 2020 ... You are correct to protect the cell that contains the IMPORTRANGE formula. If you don't protect that cell, then anyone access other parts.
Need help with Array Formula and static and dynamic data ...
https://support.google.com/docs/thread/109821503/need-help-with-array-formula-and-static-and-dynamic-data-alignment?hl=en May 14, 2021 ... But if I add another entry from Cassandra tab, it bumps column A-O down, but not the rest of the columns. Is there a way to fix this so the the ...
Can I prevent down-fill from incrementing *every* cell reference in a ...
https://support.google.com/docs/thread/5225132/can-i-prevent-down-fill-from-incrementing-every-cell-reference-in-a-formula?hl=en Apr 30, 2019 ... I have a spreadsheet with rows of data. At the end of each row I have a formula that computes a useful number based on (1) the row and (2) ...
Duplicated sheets don't protect ranges - Google Docs Editors ...
https://support.google.com/docs/thread/211853672/duplicated-sheets-don-t-protect-ranges?hl=en Apr 19, 2023 ... I can go to each sheet and choose "protect sheet" with "except certain cells" but it's incredibly time-consuming to go through and select all of ...
Insert new rows and include all formulas - Google Docs Editors ...
https://support.google.com/docs/thread/7173404/insert-new-rows-and-include-all-formulas?hl=en May 31, 2019 ... I've included a link to the sheet below and you can see how the new blank row I've added does not contain the formulas and the row after has ...
Copy paste a formula, only change 1 of the several references ...
https://support.google.com/docs/thread/132671332/copy-paste-a-formula-only-change-1-of-the-several-references?hl=en Oct 27, 2021 ... Does anyone know a way to copy paste the formula with only the cell S2 increasing everytime it is pasted under each other, so the other numbers ...
Issue with FILTER formula data disappearing when sorting - Google ...
https://support.google.com/docs/thread/248999121/issue-with-filter-formula-data-disappearing-when-sorting?hl=en Dec 18, 2023 ... When I sort a column AZ all the data in the rows disappear, since the FILTER formula is now no longer in the top of the cells.
Format "Today()" within a formula containing text - Google Docs ...
https://support.google.com/docs/thread/15874162/format-today-within-a-formula-containing-text?hl=en Oct 2, 2019 ... This question is locked and replying has been disabled. I have ... If you need to use the date from that cell in a formula later on you ...
Maintaining row alignment across tabs when referencing columns ...
https://support.google.com/docs/thread/64420147/maintaining-row-alignment-across-tabs-when-referencing-columns-from-master-sheet-with-sorting?hl=en Aug 13, 2020 ... In addition to this, It is important not to have mixed data types in each column. This can cause issues with other formulas when data is ...
How to protect a cell with formula but allow user to copy the the ...
https://support.google.com/docs/thread/56106055/how-to-protect-a-cell-with-formula-but-allow-user-to-copy-the-the-content-of-that-protected-cell?hl=en Jun 28, 2020 ... I have a spreadsheet with formulas in various cells that I need to protect from the users. ... In Microsoft Excel, you can protect the ...
Google Sheets Find and Replace not working - Google Docs Editors ...
https://support.google.com/docs/thread/164736927/google-sheets-find-and-replace-not-working?hl=en May 24, 2022 ... Do the "Hello_Ex" cells contain formulas, by any chance? Note that you need to click Replace in the Edit > Find and replace dialog box ...