About 1,646,381 results (4,857 milliseconds)
Re: Problems deleting filtered rows
https://groups.google.com/g/microsoft.public.excel/c/z3ISO4TOdlU 2/20/08... Delete. You do not have permission to delete messages in this group ... I usually use the Filter function when dealing with data in Excel. ... delete from filtered data without it ...
Sheets Filter not working correctly - Google Docs Editors Community
https://support.google.com/docs/thread/13200579/sheets-filter-not-working-correctly?hl=en Aug 30, 2019 ... Select your filtered row. Click the filter button without going into the drop down. this will remove the filters. then select the row again and ...
Rows have disappeared (not hidden) from sheet - - Google Docs ...
https://support.google.com/docs/thread/200270506/rows-have-disappeared-not-hidden-from-sheet?hl=en Feb 3, 2023 ... ... Remove filter, from the menu bar, and the lost rows should reappear. You can keep working now, without the data filter, if you don't need it ...
I am using google sheets and there seems to be a random break ...
https://support.google.com/docs/thread/66063986/i-am-using-google-sheets-and-there-seems-to-be-a-random-break-the-green-line-in-my-table?hl=en Aug 20, 2020 ... I have also tried to delete rows bordering that break but the break just moved up. ... Community content may not ... filtered if you use one of the ...
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 ... In column A click the filter drop down; Click "Clear" to clear all values, then click (Blanks) so that it is the only item checked; Click OK ...
How do I filter out rows on a sheet that are highlighted a certain color ...
https://support.google.com/docs/thread/18286071/how-do-i-filter-out-rows-on-a-sheet-that-are-highlighted-a-certain-color-which-you-can-in-excel?hl=en Nov 1, 2019 ... ... Excel? I don't see a filter option for ... I want to keep the data in the sheet, just temporarily remove ... not just filter out the duplicates and ...
Filter out blank rows in named range - Google Docs Editors ...
https://support.google.com/docs/thread/44123024/filter-out-blank-rows-in-named-range?hl=en May 3, 2020 ... A:A<>""). This formula will take all of the contents from column A of Sheet1 and remove the blank rows. If this is not what ...
Delete rows from a table that contain data from another table ...
https://support.google.com/docs/thread/138125243/delete-rows-from-a-table-that-contain-data-from-another-table?hl=en Dec 1, 2021 ... ... filter by values". At the bottom of that menu box, uncheck the "Cancelled" option, and those rows will not be displayed. If you do that, you ...
Want to Remove rows on condition in google sheet - Google Docs ...
https://support.google.com/docs/thread/60982390/want-to-remove-rows-on-condition-in-google-sheet?hl=en Jul 25, 2020 ... If so, that's not really deleting rows, it's filtering out rows from one dataset to another using the following QUERY() function. =QUERY ...
How to hide/collapse rows on a Google Sheet? Used to be able to ...
https://support.google.com/docs/thread/5155428/how-to-hide-collapse-rows-on-a-google-sheet-used-to-be-able-to-not-hide-a-sheet-hide-rows?hl=en Apr 29, 2019 ... ... delete but also do not need ... Unfortunately, I have not been able to implement a filter ... rows of a certain level is not visible on my worksheet ...
Formulas to reflect filter and omit hidden rows - Google Docs Editors ...
https://support.google.com/docs/thread/74937318/formulas-to-reflect-filter-and-omit-hidden-rows?hl=en Oct 4, 2020 ... In this spreadsheet I have multiple formulas in Row 2. ... not be responsive to the Filter. ACTION ITEM ... Delete all the column headers in row 5 ( ...
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 ... Click Data Remove filter. Right click on any cell then click Remove filter. Once filtered, at the bottom right users can see the number of rows ...
how can we unhide rows in google sheet - Google Docs Editors ...
https://support.google.com/docs/thread/10128182/how-can-we-unhide-rows-in-google-sheet?hl=en Jul 18, 2019 ... Nevermind -- my bad ... a filter in a column was hiding row #2, not the hide a row feature. Sorry, thought I'd update the post in case anyone ...
Selecting cell range while having a filter on? - Google Docs Editors ...
https://support.google.com/docs/thread/95171533/selecting-cell-range-while-having-a-filter-on?hl=en Jan 27, 2021 ... In Excel, it's a no-brainer... ... This should not be the filter's behavior, as one can see from this .gif: ... filter on, they will copy to rows ...
Frustration with filter views - what am I missing? - Google Docs ...
https://support.google.com/docs/thread/108177939/frustration-with-filter-views-what-am-i-missing?hl=en Apr 30, 2021 ... Delete the filter view, select the cells again, then click the filter button ... rows and columns IN THE MIDDLE without it not getting filtered.
"You can't create a filter over a range containing vertical merges ...
https://support.google.com/docs/thread/4927858/you-can-t-create-a-filter-over-a-range-containing-vertical-merges-msg-in-google-sheets-no-merge?hl=en Apr 26, 2019 ... You need to check your spreadsheet very carefully as merged cells are not always obvious. If there are merged cells it may have been ...
My pivot table filter doesn't work - Google Docs Editors Community
https://support.google.com/docs/thread/37064891/my-pivot-table-filter-doesn-t-work?hl=en Mar 31, 2020 ... rather than paring down columns, start by pairing down rows. that is, File>Make a Copy of your sheet, then on that new sheet, delete all but 20 ...
Only Copy and Paste VISIBLE cells in Google Sheets - Google Docs ...
https://support.google.com/docs/thread/38767079/only-copy-and-paste-visible-cells-in-google-sheets?hl=en Apr 9, 2020 ... ... not own Excel. Google Sheets has been ... (2 and 3 points are only for explanation. you can just hide the unwanted rows using 'filter by condition ...
How to stop filter view from automatically treating first row as header ...
https://support.google.com/docs/thread/122241993/how-to-stop-filter-view-from-automatically-treating-first-row-as-header?hl=en Aug 21, 2021 ... I suspect it's not possible...? Thanks for any info. Details. Sheets,Microsoft Windows,Personal use. Locked. This question is locked and ...
AutoCrat merge stops/get's stuck with "Starting at..."
https://groups.google.com/g/nv-autocrat-add-on/c/9cjSPe6WClo The way to control which rows get used is either by a filter in the setup or putting something in the status column. Autocrat will not process a row with ...