About 1,274,879 results (1,304 milliseconds)
Advanced filter function in Excel - Google Docs Editors Community
https://support.google.com/docs/thread/9779002/advanced-filter-function-in-excel?hl=en Jul 12, 2019 ... I would like to use the Advanced Filter Function that is on Microsoft Excel, but can't seem to find it in Google Sheets.
Sort and Filter with protected cells. No Filter View! - Google Docs ...
https://support.google.com/docs/thread/75804143/sort-and-filter-with-protected-cells-no-filter-view?hl=en Oct 9, 2020 ... Moreover, when people who use my data are not that Excel/Google sheets savvy, to put it mildly. You see, Google, not all of the people who use ...
Sort & filter your data - Computer - Google Docs Editors Help
https://support.google.com/docs/answer/3540681?hl=en&co=GENIE.Platform%3DDesktop You can sort data in alphabetical and numerical order, or use filters to hide data you don't want to see. To get an example spreadsheet and follow along with ...
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 ... ... Excel 2010 with 1 button click (located next to the filter icon). I have a data base with 100+ columns, so if I apply many filters, then ...
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 ... One way in which Excel and Sheets do, in fact, differ from one another is in that Sheets allow you to copy (ctrl/command + C) and paste a ...
"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 ... Hi, Tracy,. If you are getting that message you do have merged cells. You need to check your spreadsheet very carefully as merged cells are not ...
Sheets Filter not working correctly - Google Docs Editors Community
https://support.google.com/docs/thread/13200579/sheets-filter-not-working-correctly?hl=en Aug 31, 2019 ... In the sheet that you would like to use the Filter Views, turn off ... We imported the excel spreadsheet into google docs so we can all share this ...
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 ... How do I filter out rows on a sheet that are highlighted a certain color, which you can in Excel? I don't see a filter option for highlight ...
RE: Create separate pivot chart for each filter
https://groups.google.com/g/microsoft.public.excel.charting/c/jqzyoyUs_1Y > In Excel, Pivot Charts - When filtering in a pivot table, how do you create a > ... > when you change the filter criteria. xsaed's profile photo. xsaed.
Keep the formatting when using FILTER function - Google Docs ...
https://support.google.com/docs/thread/49711122/keep-the-formatting-when-using-filter-function?hl=en May 28, 2020 ... But if you have just setup borders, column widths, or conditional formatting that is based on the whole range, the way I do this is to make a ...
Trying to duplicate an Excel process used to minimize repetitive ...
https://support.google.com/docs/thread/236471267/trying-to-duplicate-an-excel-process-used-to-minimize-repetitive-filtering-for-data-output?hl=en Sep 25, 2023 ... Excel slicers allows anyone to use buttons instead of filtering, copy/paste and unfiltering. I have been asked to move the process to Sheets ...
How do I stop filter messing up my formula? - Google Docs Editors ...
https://support.google.com/docs/thread/105856519/how-do-i-stop-filter-messing-up-my-formula?hl=en Apr 11, 2021 ... How do I stop filter messing up my formula? · Cell G4 =L59*(F4/100) · etc. · When I filter the data, Sheets alters all the references. · Cell G3 =$ ...
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 ... ... use one of the filter drop downs in the green row. You can completely remove the line by going to the Data menu and selecting "Turn off Filter.
I'm using a filter formula; How do I skip a row and make 2nd group of ...
https://support.google.com/docs/thread/133800314/i-m-using-a-filter-formula-how-do-i-skip-a-row-and-make-2nd-group-of-rows-show-after-the-1st-group?hl=en Nov 3, 2021 ... However, I do not want the "Subtotal" row to show. As of now, my workaround is to add a column of cells where I can ad a "1" if I want that ...
Sort & filter your data - Android - Google Docs Editors Help
https://support.google.com/docs/answer/3540681?hl=en&co=GENIE.Platform%3DAndroid Use a conditional filter · On your Android phone or tablet, open a spreadsheet in the Google Sheets app. · Tap More More and then Create a filter. · At the top of ...
Excel auto filter as you type - Google Docs Editors Community
https://support.google.com/docs/thread/25814844/excel-auto-filter-as-you-type?hl=en Jan 16, 2020 ... ... filter to all columns? Please advise how do it. Thank you :) Edit: I'm unable to attach the excel file. Here's the link where I got the ...
Google Sheets: Column filter not working - Google Docs Editors ...
https://support.google.com/docs/thread/3082766/google-sheets-column-filter-not-working?hl=en Mar 26, 2019 ... This is a sheet that was imported from Excel so I don't know if that has anything to do with it but it was working fine in Excel and now is not.
How to share sheets with Multiple people but they can see only what ...
https://support.google.com/docs/thread/54402092/how-to-share-sheets-with-multiple-people-but-they-can-see-only-what-they-require-to?hl=en Jun 20, 2020 ... ... make a copy"), then adjust for each. I like to make the FILTER function reference cell(s) on the same sheet (typically cells A1 and B1 so it ...
Save and Restore AutoFilter
https://groups.google.com/g/exceldna/c/P4czzE9x6rA Jun 4, 2012 ... with the workbook; when I reopen the workbook the filter settings are ... it would allow me to use the full Excel 2010 functionality (as opposed
How to set custom view filter columns in Google Sheets? - Google ...
https://support.google.com/docs/thread/2266784/how-to-set-custom-view-filter-columns-in-google-sheets?hl=en Mar 12, 2019 ... I've made good use of the Filter Views, but these only hide info within the column - not the whole columns themselves. What solution would ...