About 1,841,263 results (1,145 milliseconds)
Clean up data in a spreadsheet | Google Workspace Add-ons ...
https://developers.google.com/workspace/add-ons/samples/clean-sheet Delete blank columns–Within a selected range, the script identifies empty columns and deletes them. If cells within a column contain space characters, the ...
In google sheet, how to clear all filters rules in 1 click without ...
https://support.google.com/docs/thread/242083878/in-google-sheet-how-to-clear-all-filters-rules-in-1-click-without-deleting-the-filters-solved?hl=en Nov 2, 2023 ... One was creating a macro that goes through each column and unfilters. It doesn't work for me because I'm constantly adding columns, so would ...
Hide Columns based on a cell value
https://groups.google.com/g/microsoft.public.excel.worksheet.functions/c/AjuWeUbLAW0 Jul 3, 2009 ... a clear explanation of what you want and before/after examples. -- Don Guillett Microsoft MVP Excel SalesAid Software [email protected]
Cell reference in VBA
https://groups.google.com/g/microsoft.public.excel.worksheet.functions/c/dQLPGyMWDMA ... vba so that when i insert or delete columns, my macros don't get messed up by referring to specific columns: I have these 2 lines of code in one of my macros.
[Excel Dna]... Insert a simple row
https://groups.google.com/g/exceldna/c/gQTB8a3wkcU Delete. You do not have permission to delete messages in this group. Copy ... Macros in Excel-DNA add-ins are always hidden, so you would need to types ...
My File Won't Open In Google Sheets - Google Docs Editors ...
https://support.google.com/docs/thread/101344075/my-file-won-t-open-in-google-sheets?hl=en Mar 8, 2021 ... XLTM format (Excel Macro Enabled Template). ... Unless I delete data from the EXCEL FILE, such as deleting some of the worksheets or columns or ...
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 ... Edit: Note that if you INSERT or DELETE a column/row it will change ...
Number sequencing does not work if there is a merged cell included ...
https://support.google.com/docs/thread/198238958/number-sequencing-does-not-work-if-there-is-a-merged-cell-included?hl=en Jan 20, 2023 ... I was able to have a macro in Excel which was able to do this: Now that I have moved on to Google Sheets, I tried all I could do, but I'm unable ...
Class Sheet | Apps Script | Google for Developers
https://developers.google.com/apps-script/reference/spreadsheet/sheet Jan 18, 2024 ... The position of the first column to delete. howMany, Integer, The number of columns to delete. Authorization. Scripts that use this method ...
Script function in Sheets are very slow - Google Docs Editors ...
https://support.google.com/docs/thread/42793831/script-function-in-sheets-are-very-slow?hl=en Apr 27, 2020 ... The simplest example is that I want to clear every tick box in a column. Script is below. My test sheet has 5 rows, and I'd expcted that ...
Pasting Excel into Tiddler -- Convert to Table
https://groups.google.com/g/tiddlywiki/c/REJl-66vSSU I"ve previously used an excel formula to generate wiki markup for a whole table row in a single excel column. Then I could copy just that single Excel column, ...
Help with Google Sheets Macro to Insert Row based on Value ...
https://support.google.com/docs/thread/176518794/help-with-google-sheets-macro-to-insert-row-based-on-value?hl=en Aug 24, 2022 ... I have Column I of a spreadsheet containing two values only. "Yes ... remove fields etc). function PrepareDataSheet() {. var spreadsheet ...
ExcelAsyncUtil.QueueAsMacro is breaking the UNDO history
https://groups.google.com/g/exceldna/c/_NQvVgzpgdI This is what Excel always does when a macro is run - whether Excel-DNA or VBA or whatever. You can set a fresh macro as the current "Undo" macro by calling ...
How to delete blank rows and columns across multiple sheets at ...
https://support.google.com/docs/thread/112021090/how-to-delete-blank-rows-and-columns-across-multiple-sheets-at-once?hl=en Jun 1, 2021 ... First off, paste the code into the script editor (Tools > Script editor), press the bug button to authenticate the script and save.
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 ...
Google sheet macro - complete status moves row to another tab and ...
https://support.google.com/docs/thread/28381517/google-sheet-macro-complete-status-moves-row-to-another-tab-and-clears-certain-cells-in-current?hl=en Feb 11, 2020 ... Cannot clear entire row as need to keep the formulas in relevant columns and conditional formatting etc. Cannot delete it as need this to be ...
Find and delete/replace in Macro - Google Docs Editors Community
https://support.google.com/docs/thread/136230394/find-and-delete-replace-in-macro?hl=en Nov 19, 2021 ... I usually highlight the columns and then do "find and replace the " with nothing" so just the number is left in the cell. Of course I learned ...
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 ... ... macro. I simply clicked record macro and then manually cleared out the cells I wanted to delete and then saved. Once I saved I then drew a ...
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 ... Were you able to get the macro option working? That is a valid option but could be more involved than actually required. Do you happen to have a ...
How do I delete several columns using a Google Sheets script ...
https://support.google.com/docs/thread/53508440/how-do-i-delete-several-columns-using-a-google-sheets-script?hl=en Jun 14, 2020 ... ... Macro deleting columns. The Macro will record all your actions in the script in Google's API language. But, to answer your question this is ...