About 1,093,764 results (4,665 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 ... Use your mouse to highlight/select your entire sheet · Click the filter icon · In column A click the filter drop down · Click "Clear" to clear all ...
Filter view to show only rows with nothing in column A - Google ...
https://support.google.com/docs/thread/29701020/filter-view-to-show-only-rows-with-nothing-in-column-a?hl=en Feb 24, 2020 ... I believe that there is a bug because when you select (blanks), then all of the rows that have column B blank should be shown. However ...
Navigating, pasting, formatting, and selecting tables in Google Docs ...
https://support.google.com/docs/thread/38979971/navigating-pasting-formatting-and-selecting-tables-in-google-docs?hl=en Apr 9, 2020 ... I exported the Google doc to a Word doc, selected the entire table (Select>Table), chose format and realigned the cells all at once, and then selected the ...
Using QUERY and IMPORTRANGE to import only select columns in ...
https://support.google.com/docs/thread/225654384/using-query-and-importrange-to-import-only-select-columns-in-some-sheets?hl=en Jul 14, 2023 ... I need the select statement at the end as the rest of the rows in the sheet are preformatted with drop downs in some so there were lots of blank ...
Query: Select only non-blank columns - Google Docs Editors ...
https://support.google.com/docs/thread/152355118/query-select-only-non-blank-columns?hl=en Feb 26, 2022 ... I want to select only non-blank columns. I've tried with transpose and filter and can do it in steps, but it's a mission.
Need to pull specific data out of individual rows and create ...
https://support.google.com/docs/thread/276446740/need-to-pull-specific-data-out-of-individual-rows-and-create-individual-forms-or-reports-per-row?hl=en May 25, 2024 ... The Google sheet was created from a Google form where customers could only select the above values per book listed, or leave it blank. (The ...
Remove blank rows from IMPORTXML result - Google Docs Editors ...
https://support.google.com/docs/thread/35415791/remove-blank-rows-from-importxml-result?hl=en Mar 24, 2020 ... ... select Col1" to only choose the first column of data. =QUERY(IMPORTXML("https://animalcrossing.fandom.com/wiki/Fish_(New_Horizons)","//td/a ...
how to insert blank row between each change in dates in google ...
https://support.google.com/docs/thread/25744916/how-to-insert-blank-row-between-each-change-in-dates-in-google-sheets?hl=en Jan 16, 2020 ... Here in this sheet I would use the helper column "M" to find and select all "FALSE" and use cntrl+ to insert a row. ... Your sample spreadsheet is ...
Why is my queried data disappearing when I order by a column ...
https://support.google.com/docs/thread/158888242/why-is-my-queried-data-disappearing-when-i-order-by-a-column?hl=en Apr 6, 2022 ... I deleted all but 20 of those blank rows. I would recommend that you ... choose rows, and then apply a filter view to show those rows only.
Conditional Formatting: If A is not blank and either M or N are blank ...
https://support.google.com/docs/thread/27765511/conditional-formatting-if-a-is-not-blank-and-either-m-or-n-are-blank-highlight-the-blank-cell?hl=en Feb 6, 2020 ... (This part works fine -- under "Conditional Formatting" I select "Is Empty" and choose the color I want to highlight.) However, I only want to ...
How do I filter with a set of variables, but only if they are selected ...
https://support.google.com/docs/thread/3534001/how-do-i-filter-with-a-set-of-variables-but-only-if-they-are-selected?hl=en Apr 4, 2019 ... I have another worksheet with drop down cells listing all ... Right now, if I add the conditions, it would return only rows with blank cells.
Hi all, I'm wanting to move rows to the completed tab when they are ...
https://support.google.com/docs/thread/37125382/hi-all-i-m-wanting-to-move-rows-to-the-completed-tab-when-they-are-ticked-in-column-a?hl=en Mar 31, 2020 ... Of course when you check a box back to FALSE on the "Completed Tasks" sheet it will put it under the next available empty row and not back into ...
Easiest way to insert multiple copied rows?
https://groups.google.com/g/microsoft.public.mac.office.excel/c/zNf0gGlLZk8 Apr 24, 2010 ... This works great but only works for copying one row below. What if I want to copy 2 or 3 rows below? I can find blank rows, copy them, and ...
Move columns together when sorting - Google Docs Editors ...
https://support.google.com/docs/thread/106913837/move-columns-together-when-sorting?hl=en Apr 20, 2021 ... Note that data filters may only apply to some rows, if you don't select all of the sheet - blank rows force it to stop. But that should not ...
Need formula to insert blank row every nth row - Google Docs ...
https://support.google.com/docs/thread/60204692/need-formula-to-insert-blank-row-every-nth-row?hl=en Jul 22, 2020 ... ... blank resuming with data for another 5 rows until the next blank row is inserted and so on. I tried finding a formula that does this but all ...
In google sheets can I set it so that all cells word wrap and align at ...
https://support.google.com/docs/thread/4372413/in-google-sheets-can-i-set-it-so-that-all-cells-word-wrap-and-align-at-top-by-default?hl=en Apr 17, 2019 ... I can select cells, rows, and columns - and even the entire ... Or are you text-only pasting all data into a blank spreadsheet that was previously ...
How to add a blank option in a data validation drop down list ...
https://support.google.com/docs/thread/5750893/how-to-add-a-blank-option-in-a-data-validation-drop-down-list?hl=en May 8, 2019 ... the blank option isn't showing up when i select the drop down menu, only yes or no. Details. Sheets,Microsoft Windows,Personal use. Locked.
Automatically Hide/Reveal Rows Without Text - Google Docs Editors ...
https://support.google.com/docs/thread/217673738/automatically-hide-reveal-rows-without-text?hl=en May 26, 2023 ... Automatically Hide/Reveal Rows Without Text. Hi, I know this has been discussed before, but I'm not finding a solution for my ...
How to automatically format cell colors based on Booleans - Google ...
https://support.google.com/docs/thread/5542742/how-to-automatically-format-cell-colors-based-on-booleans?hl=en May 6, 2019 ... What I'd like to do is set up a formula with instructions like: for all rows, if End Use Date column is not empty, set row color to red. But I'm ...
Sheets Query and Importrange intermittently fail to return all rows ...
https://support.google.com/docs/thread/124499116/sheets-query-and-importrange-intermittently-fail-to-return-all-rows?hl=en Sep 5, 2021 ... ... Select * Where A is not null",0). The Query command frequently fails to import several of the final rows. IIRC, this can amount to up to five ...