About 1,932,832 results (5,983 milliseconds)
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 ... Please share your concerns about this directly with the Sheets team by opening a Sheets file and going to Help > Help Sheets improve. The ...
Remove blank cells in multiple columns and consoliate into one row ...
https://support.google.com/docs/thread/214974455/remove-blank-cells-in-multiple-columns-and-consoliate-into-one-row?hl=en May 10, 2023 ... I'm trying to create a formula that consolidates information from B2:B, F2:F, J2:J, N2:N, R2:R, V2:V, Y2:Y (highlighted green on sheet 1) onto sheet2
arrays stacked vertically, omitting blanks - Google Docs Editors ...
https://support.google.com/docs/thread/32446468/arrays-stacked-vertically-omitting-blanks?hl=en Mar 5, 2020 ... ... blank rows (made blank via a nested 'substitute' formula). ... The tab "result 1" is the base formula to remove blank rows with tab "src 1" as ...
Google Sheets adds hundreds of blank rows that can't be deleted ...
https://support.google.com/docs/thread/106892132/google-sheets-adds-hundreds-of-blank-rows-that-can-t-be-deleted?hl=en Apr 20, 2021 ... The problem is that my formula keeps adding about 500 extra blank rows underneath the class lists. When I delete them, they just pop right back up.
Combine phrases in multiple cells into one cell, removing duplicate ...
https://support.google.com/docs/thread/6047360/combine-phrases-in-multiple-cells-into-one-cell-removing-duplicate-phrases?hl=en May 13, 2019 ... Do you know how to make this formula to execute automatically for non-empty rows? So that your formula will be in the second cell of a column ...
Import certain columns from one sheet to another. - Google Docs ...
https://support.google.com/docs/thread/9516260/import-certain-columns-from-one-sheet-to-another?hl=en Jul 8, 2019 ... You can usually remove blanks but I'm not sure where you are in the process. Show me the formula (or sample sheet is better) which is currently ...
How to remove unwanted spaces - Google Docs Editors Community
https://support.google.com/docs/thread/188915830/how-to-remove-unwanted-spaces?hl=en Nov 16, 2022 ... I have tried the "TRIM" formula, but it only removed some ... FYI using "Data-->Cleanup-->Trim White Spaces" from the menu did not ...
Forms responses adding new rows rather than overwriting blank ...
https://support.google.com/docs/thread/15177338/forms-responses-adding-new-rows-rather-than-overwriting-blank-ones?hl=en Sep 25, 2019 ... Try using this formula: . =indirect(concat("'Form Responses'!A ... extra column with these numbers in your calculation sheet). This ...
Splitting and flatting array causes to have unwanted extra blank rows
https://support.google.com/docs/thread/200821623/splitting-and-flatting-array-causes-to-have-unwanted-extra-blank-rows?hl=en Feb 7, 2023 ... using this formula makes equal amount of blank rows which in turn ... ideal result is removal of those blank rows for ex: J8:J22. , J24 ...
How can I import data from multiple spreadsheets and compile it into ...
https://support.google.com/docs/thread/4607921/how-can-i-import-data-from-multiple-spreadsheets-and-compile-it-into-a-continuous-list?hl=en Apr 21, 2019 ... I was thinking of using google forms, but the customization was lacking for my needs. ... blank rows between each sheet (added the formula on the ...
How do I add a row to a table without it automatically changing the ...
https://support.google.com/docs/thread/87022216/how-do-i-add-a-row-to-a-table-without-it-automatically-changing-the-cell-references-in-another-cell?hl=en Dec 5, 2020 ... My actual formula is rather complex, so I'll use a simplified example here to get my point across. I have a Google Spreadsheet, with two sheets ...
Problem using Data Validation to prevent duplicate entries in ...
https://support.google.com/docs/thread/150859914/problem-using-data-validation-to-prevent-duplicate-entries-in-google-sheets?hl=en Feb 15, 2022 ... The cell references in the formula are off by one row. Cell A131 is blank, which makes the formula return false . Most of the other ...
Use "Join" function on range and exclude blank rows? - Google ...
https://support.google.com/docs/thread/18674277/use-join-function-on-range-and-exclude-blank-rows?hl=en Nov 5, 2019 ... ... blank rows at the end. I imagine this involves using an array formula but I was struggling to get the syntax correct. Details. Sheets,Mac OS ...
Change multiple cells based on one cell - Google Docs Editors ...
https://support.google.com/docs/thread/158571517/change-multiple-cells-based-on-one-cell?hl=en Apr 5, 2022 ... I tried to use an IF formula but I couldn't make it work so I don't think I was using it correctly. ... This formula reads: If H14 is blank or G14 ...
I'm getting #ref when deleting rows. Is there a way to avoid this ...
https://support.google.com/docs/thread/84417645/i-m-getting-ref-when-deleting-rows-is-there-a-way-to-avoid-this?hl=en Nov 21, 2020 ... If my Manager deletes a row on the schedule tab, it causes a #ref error on the formulas & calculations tab. I'm not too familiar with excel or ...
Can I create an auto copy row to another sheet? - Google Docs ...
https://support.google.com/docs/thread/9604277/can-i-create-an-auto-copy-row-to-another-sheet?hl=en Jul 10, 2019 ... ... multiple trigger values, or moving rows to a tab in another spreadsheet file. ... using the version of your script that doesn't delete the ...
Optional Button for Adding Rows & Columns & Way to Add >1 at a ...
https://support.google.com/docs/thread/152809645/optional-button-for-adding-rows-columns-way-to-add-1-at-a-time?hl=en Mar 1, 2022 ... Even when using hotkeys to add 15 rows, it takes a long time. ... empty rows at the end then it will add columns. The formula is meant to ...
can't see cells & columns - Google Docs Editors Community
https://support.google.com/docs/thread/218052353/can-t-see-cells-columns?hl=en May 28, 2023 ... Deleting unwanted columns and rows is a good thing to do, especially when the file is quite large, or has complex arrayformula calculations to ...
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 ... Excel formulas are not the same as Google Sheets functions. I was wondering why you are using Google Sheets and using the Microsoft Excel file ...
Formula to remove blanks and shift data - Google Docs Editors ...
https://support.google.com/docs/thread/23664448/formula-to-remove-blanks-and-shift-data?hl=en Dec 23, 2019 ... I would like to delete these empty cells and shift data to line up removing the blanks. In Excel, I know you can use Ctrl + G and select the empty cells, then ...