About 1,811,221 results (4,544 milliseconds)
How to clear a column of values without losing headers? (header ...
https://support.google.com/docs/thread/2687134/how-to-clear-a-column-of-values-without-losing-headers-header-rows-are-frozen?hl=en Mar 19, 2019 ... Is there a way to clear data from a (very long) column without losing the info in (frozen) headers? I use 2 rows as headers, one for the title ...
Is there a way to delete multiple blank rows all at once without doing ...
https://support.google.com/docs/thread/199083324/is-there-a-way-to-delete-multiple-blank-rows-all-at-once-without-doing-them-in-groups?hl=en Jan 26, 2023 ... Click "Clear" to clear all values, then click (Blanks) so that it is the only item checked; Click OK; Select all empty rows with your mouse ...
How do I clear contents of a cell or multiple cells? - Google Docs ...
https://support.google.com/docs/thread/120509506/how-do-i-clear-contents-of-a-cell-or-multiple-cells?hl=en Aug 9, 2021 ... To clear multiple (discontinuous) cells, select the first one, hold down <Ctrl>, then click on the other cells you want, and then the Delete key.
How do I clear contents in a cell but keep the formula in google ...
https://support.google.com/docs/thread/101825326/how-do-i-clear-contents-in-a-cell-but-keep-the-formula-in-google-sheets?hl=en Mar 11, 2021 ... I'm having trouble figuring out how to clear contents in the cell but keep the formula, so that when I input new info, the cleared cell will generate the new ...
How do I clear the content within a range based on the value of a ...
https://support.google.com/docs/thread/17354642/how-do-i-clear-the-content-within-a-range-based-on-the-value-of-a-cell?hl=en Oct 21, 2019 ... I'm looking for a way to clear their orders simultaneously by performing an action on my own administrative spreadsheet.
Clear entries on sheet at specific time (midnight) - Google Docs ...
https://support.google.com/docs/thread/215719582/clear-entries-on-sheet-at-specific-time-midnight?hl=en May 14, 2023 ... (something like a time based trigger to clear the column values.) ... Learn Google Sheets & Excel Spreadsheets - YouTube · Sheets Ninja ...
How can I remove the #VALUE error without removing the formula ...
https://support.google.com/docs/thread/56529966/how-can-i-remove-the-value-error-without-removing-the-formula?hl=en Jul 1, 2020 ... I'm trying to create a simple timesheet, but my issue is that I'd like for column D to remain empty and not figure in any corresponding ...
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 ... Select cells, open the data validation menu and remove validation. The data validation menu has been changed to a list of rules for the whole spreadsheet.
In google sheet, how to clear all filters rules in 1 click without ...
https://support.google.com/docs/thread/19196689/in-google-sheet-how-to-clear-all-filters-rules-in-1-click-without-deleting-the-filters?hl=en Nov 10, 2019 ... I used to be able to this in Excel 2010 with 1 button click (located next to the filter icon). I have a data base with 100+ columns, so if I ...
how do I delete data in a cell without deleting formula?
https://groups.google.com/g/microsoft.public.excel.worksheet.functions/c/iHkISAiUe_4 Apr 20, 2008 ... Edit>Clear>Contents or just hit the delete key. Gord Dibben MS Excel MVP. On Sun, 20 Apr 2008 14:44:00 -0700, tripy <tr...@discussions ...
Clear cells content
https://groups.google.com/g/exceldna/c/MSVsGS5FSMI excel(xlcall.xlcClear, xlRef); xlcall.excel(xlcall.xlcClear, 3, xlRef); ... object[,] values = new object[rows, cols]; // nulls xlRef.SetValue(values);
How to clear or delete range of cells in an excel file
https://groups.google.com/g/comp.soft-sys.matlab/c/t6ydNg7xlqk Dec 1, 2010 ... when you save data as *.xls using "xlswrite". If you want to keep the formatting too, you can check File Exchange for other functions to create ...
How to clear all the contents in a table without deleting the table ...
https://support.google.com/docs/thread/154534712/how-to-clear-all-the-contents-in-a-table-without-deleting-the-table?hl=en Mar 11, 2022 ... However, I want to preserve the table, i.e. an empty table after deletion. Is it possible? The only workaround is to delete some cells and then ...
Split text, remove duplicates, or trim whitespace - Computer - Google ...
https://support.google.com/docs/answer/6325535?hl=en&co=GENIE.Platform%3DDesktop Split data into columns You can split clearly defined data, like text separated by commas, into several columns with Google Sheets. For example, a column ...
I need a script to clear certain cells in sheets when a button is ...
https://support.google.com/docs/thread/5809954/i-need-a-script-to-clear-certain-cells-in-sheets-when-a-button-is-pressed?hl=en May 9, 2019 ... //clear contents in my spreadsheet. var app = SpreadsheetApp. var activesheet = app.getActiveSpreadsheet().getActiveSheet(). activesheet ...
How to delete data, but keep SUM? - Google Docs Editors Community
https://support.google.com/docs/thread/200273477/how-to-delete-data-but-keep-sum?hl=en Feb 3, 2023 ... How to delete data, but keep SUM? Hello,. I am very new to this. The problem is, lets say I have 10 bananas in cell A1 and want to add 2 ...
Delete duplicate rows in some columns and leave data in other ...
https://support.google.com/docs/thread/130347062/delete-duplicate-rows-in-some-columns-and-leave-data-in-other-columns?hl=en Oct 11, 2021 ... As you did notice your spreadsheet was an Excel format and not a Google Sheets file and that is why you were having a problem. Excel formulas ...
Clear cells with checkbox - Google Docs Editors Community
https://support.google.com/docs/thread/52857581/clear-cells-with-checkbox?hl=en Jun 11, 2020 ... I need the black check boxes in B2, D2 and F2 to clear the contents of the cells next to them so that: If the checkbox in B2 is checked (set to true") it ...
Google Sheets: Find and replace/delete many values at once ...
https://support.google.com/docs/thread/125735942/google-sheets-find-and-replace-delete-many-values-at-once?hl=en Sep 13, 2021 ... Google Sheets: Find and replace/delete many values at once. I have a list of contacts in google sheets. In Column A I have Names and in ...
How to clear check boxes with a single check box - Google Docs ...
https://support.google.com/docs/thread/41115224/how-to-clear-check-boxes-with-a-single-check-box?hl=en Apr 19, 2020 ... Excellent! One thing to note is that if you have formulas looking at the unchecked condition for FALSE you might need to set the values to that ...