Get access to the complete Google Sheets masterclass here 👉 www.xelplus.com/course/google-sheets/
@Betterifitsfree3 жыл бұрын
I usually get these posts in the morning so during the day I can try them out for myself. So cool, so helpful, the way life should be. Thanks so much Leila for your efforts.
@LeilaGharani3 жыл бұрын
Thank you :) Yes. On Tuesdays so far I can only manage to get the videos out at 14:00 my time.
@aminlast23333 жыл бұрын
You rescued our department not to interrupt each others' works. Thanks
@maproductions6512 Жыл бұрын
I am watching this for the 10th time, and every time i watched it, learned a new thing about filter views! one the best illustration of How to use Google Sheets!
@djones01052 жыл бұрын
Very concise and straightforward. I was able to quickly create a filter view in a shared data, even though this is new to me. Thank you, Leila!
@lucy_1802 жыл бұрын
This was incredibly helpful. Thank you for explaining filters so clearly!
@wohinmitdemgeld5843 жыл бұрын
I really admire and enjoy the professionality of your videos. Always useful, practice oriented, to the point. Thank you!
@LeilaGharani3 жыл бұрын
Glad you like them! Thank you.
@TylerStanczak3 жыл бұрын
This is so nice to know. Really helpful information. Thanks Leila. :)
@LeilaGharani3 жыл бұрын
You're welcome : )
@gracemark59953 жыл бұрын
i never knew it o.my.god filters are available in google shetts this is helpfull👍👍
@kevindillman83003 жыл бұрын
Can you pop up a dialog box to ask what to filter? Something like this would give on-the-fly filtering a little more power. By the way, your videos are amazing! I have worked as a data analyst for over 12 years and have learned a lot from you. Keep the great videos coming!
@thinkthinktechs11193 жыл бұрын
You are google sheet icon,your tutorials have made me a master.Thanks for your amazings staffs Leila
@nightfallalicorn4246 Жыл бұрын
This is the solution for the issue I've been having with my spreadsheet. Thank you so much. I've been adding extra spreads with the filter function but I believe filter view reduces the spreadsheet size and improves performance. As well as make it cleaner.
@salehmohammad51703 жыл бұрын
Always follow you. By doing this I become expert operator at my office. Thanks for All
@LeilaGharani3 жыл бұрын
I'm happy to hear that :)
@DougHExcel3 жыл бұрын
Filter view is sure a neat option when collaborating!
@user-gz3wt9mp1h8 ай бұрын
Thank you for explaining the difference between sort and filter. I was extremely frustrated to see the filter modify the Excel from the beginning, but now I have a better idea.
@faridi-bin-Zouq3 жыл бұрын
after watching this video.... " oh wao " was my reaction... Thanks --From Pakistan
@marcotanini4083 жыл бұрын
Dear Leila, thank you for your valuable advice, always well explained. My use of gSheeet has dramatically improved and my work has become much more productive.
@LeilaGharani3 жыл бұрын
That's great to hear, Marco!
@Iam_sami_80802 жыл бұрын
Such a great tutor, i will definitely purchase your course on Udemy.
@Evildaddy9113 жыл бұрын
Thanks! I've never understood how to use filter views until now. I've had extra sheets dedicated to common filters but now can do it all in one
@LeilaGharani3 жыл бұрын
Happy to help, Matt!
Жыл бұрын
Leila, thanks a lot for such an informative video. Big thumbs up! 👍👍
@ehsanbb19836 ай бұрын
Great as always! Thank you Leila.
@LeilaGharani6 ай бұрын
Glad you liked it!
@RoryTownsendTV Жыл бұрын
Any idea to add more selections like in the example of manager typed in, could we add another option by separating it with a comma. In this way it loads everything with manager, and another selection with the info after the comma. Out can we only "search" for one
@vaibhavtodi55613 жыл бұрын
Love ur thumbnails, Leila. Which software do you use?
@nperry19702 жыл бұрын
That was excellent thanks very much. I was able to work out the number of patients seen in a given time without upsetting my dataset.
@heywillwong2 ай бұрын
So helpful thank you!
@queenkai95223 ай бұрын
Excellent video, as always.
@LeilaGharani3 ай бұрын
I appreciate that
@andremilabel37872 жыл бұрын
I wish you happiness and good luck ! thanks for the video !!!!
@BackMountainMicrogreens5 ай бұрын
Very helpful! Thank you! 😊
@ViorelClaudiuDascalescu3 жыл бұрын
Thank you for making videos for Google Sheets. I really appreciate it!
@LeilaGharani3 жыл бұрын
Thank you for dropping by : )
@shabbirkanchwala-abwaab62633 жыл бұрын
You are a REAL MASTER Creating MASTERS Me too, a master in my circle, because of YOU Thank you
@monireachtang7123 жыл бұрын
Thank you very much!
@j.k6580Ай бұрын
LOVE FILTER VIEW, TKS
@zahiragamal113 жыл бұрын
your videos are incredible, more plz!
@krono324 ай бұрын
Thank you for this video!
@LeilaGharani4 ай бұрын
Our pleasure!
@hasnainsaqib98523 жыл бұрын
what you are saying everything is so good to learn from excel .This is so nice to know really helpful information Thanks leil.:@
@danishnawaz36513 жыл бұрын
You are always Best.
@assanshadyarov96772 жыл бұрын
Thank you, Leila for such a valuable and gorgeous presentation! I have a question. My boss wants that his managers (multiple users) work in one google sheet and have access to only their range of data and at the same time don't see other colleagues' work. How can I customize filters to reach that goal? Thanks!
@salmanabid95753 жыл бұрын
Ur all videos are awesome, I have a question, how can I sum up online the numbers that I have filtered in? Because when I try to sum numbers in any column it gives me sum of complete column even the filtered out numbers are not there. Thanks
@FerdiCildiz2 жыл бұрын
awesome, thank you. that's what I'm exactly looking for.
@carlosalbertoteixeira3753 жыл бұрын
Thanks, Teacher. Greetings from Rio.
@LeilaGharani3 жыл бұрын
You are welcome, Carlos!
@jimbob1883 Жыл бұрын
Thank you Leila for an excellent presentation of Filter Views. After watching your video I opened the same shared sheet in different browsers, used filtered views, set a filter and saw that the second instance of the shared sheet did not change. However, then I hide columns in the filtered view and the second instance immediately hid the same columns that were hidden in the filtered view. Is there a way to also hide columns in one instance of a shared sheet but not impact others using the same shared sheet? Thank you again for your very helpful video on a powerful option in Google Sheets.
@davidgreen1051 Жыл бұрын
Very helpful - THANK YOU!!
@MarvinBowen9 ай бұрын
Helpful. Thank you!
@Zues643 жыл бұрын
awesome Leila! You know your stuff!
@AddeDaMan Жыл бұрын
This was a really good and instructive video
@LeilaGharani Жыл бұрын
Glad you liked it.
@svishalchaudhari3332 ай бұрын
Hi, Is it possible that if one sheet is shared with multiple users and if I am applying any filter, other wont disturb and everybody can apply there own filter and work.
@John-jt3dn2 жыл бұрын
waiting 7 mintues 45 seconds to get the answer:)
@bonareal7556 Жыл бұрын
Respect and reverence (in Russian uvazuha) to you for this informative video!
@LeilaGharani Жыл бұрын
Thank you very much!
@pablopanares8943 Жыл бұрын
Thank you so much for this..Question : how can I lock the filters? after I create the filters and leave my work , the filters are gone when i visited again the sheets. 😊
@mrkem753 жыл бұрын
hi every year i have to prepare budget for multiple number of shops through out a year. Are there any formulas to help me distribute the figures so it will match the monthly target and yearly target by stores simultaneously? assume month in columns and 40 shops in rows.
@rafatali60583 жыл бұрын
Above Superb Really Nice God bless you with your fmly I'm frm India 🙂
@LeilaGharani3 жыл бұрын
Thank you so much 🙂
@user-uj8rg2ev8i2 ай бұрын
Is there a way to protect the Filter View such that other shared users can 'View' my filter view but not be able to change the Filters? However, I want them to retain the ability to use the filter in the base view so I thinking protecting sheet is out of the question.
@myndmap75242 жыл бұрын
Excellent tutorial
@mr.jaycasey46763 жыл бұрын
Hi Leila, Thanks for your quality presentations! Question: So can I set up multiple filter views and create a data validation type dropdown so that the user can call the filter view from within the spreadsheet?
@LeilaGharani3 жыл бұрын
You'd probably need a macro to activate the Filter View from a data validation selection. That's an interesting one though. I will take a closer look.
@JinaneKarhaniRawda3 жыл бұрын
Thank you, but when I try sorting a column where it is referencing to other thing it generates a mess, EVEN in a separate view. Any tip?
@nickjones6052 жыл бұрын
Thanks for this. Is it not possible to save a Filter View that is sorted by more than 1 column? This inability is basically a deal breaker (and is easily done in AirTable). Would love to know how to accomplish this in Sheets. Not sure what I'm missing here.
@lpanebr3 жыл бұрын
The other day I was playing with the filter by function but I didn't seem to work very well. Maybe I was doing something wrong. Thanks! The filter view is an excellent feature not many people know of.
@LeilaGharani3 жыл бұрын
The problem I had filter by function was it wasn't really dynamic (at least in terms of using cell references). I had to reset it to take the new value in the cell. I guess for these cases it's best to use the Filter Function instead.
@lpanebr3 жыл бұрын
@@LeilaGharani yes, that's it. It didn't automatically refresh!
@lpanebr3 жыл бұрын
@@LeilaGharani thanks for this series in sheets. Your videos are excellent!
@vijayarjunwadkar3 жыл бұрын
Nice video! Just a question, is Filter View in Sheets comparable with Excel Custom Views? I found Sheets Filter View more easier and intuitive though!
@LeilaGharani3 жыл бұрын
Thanks Vijay. It's comparable to "Sheet View" in Excel online. I believe Sheet View is only available for online and it also has similar functionality like Filter views in Sheets. Except they seem to be a lot slower than Google Sheets. I think this will improve though as Excel Online gets better.
@user-ge8qv5je6g Жыл бұрын
Hi, very good tips as usual. I've created a tool for multiple people to use with dropdowns, the issue is because changes on google sheets are live, if multiple people are using at the same time it creates a confusion, is there an option to avoid live changes? where multiple people can use the dropdowns without chaning on the other users? Thanks
@ThisHandleIsNotTaken_Yet3 жыл бұрын
Hi Leila, How can I find a replace a value in cells that are filtered? Currently I filter a column A, find and replace in Column B, remove filter of Column A, and all the values on Column B were replaced, instead seeing the replacement in the filtered view. Thank you!
@shiwei943 жыл бұрын
I'm interested in this too, like how to filter a data, then changing the result to what you wanted the data to show
@marinayamin20564 күн бұрын
What happens if they use a filter without using the filter view? How do we work around that?
@isa3koimaui3 жыл бұрын
Very well done; thank you!
@Gaajinikanth3 жыл бұрын
I understand and learned after watching your video. Before this i thought the background in dark colour means no internet connection...
@LeilaGharani3 жыл бұрын
I'm glad this helps : )
@Gaajinikanth3 жыл бұрын
@@LeilaGharani tq for the reply
@dale356bc3 жыл бұрын
Great content. Very well explained. A+
@ManavJuneja_creative3 жыл бұрын
You make really helpful videos. Is it possible to create an online ordering Google site for my business, which gets it's input from my Google sheet's dataset and return the order summary to the sheets ?
@ConsulthinkProgrammer3 жыл бұрын
See this for reference kzbin.info/www/bejne/h3y0lWt4ja5mZq8
@anhnhatnguyet46283 жыл бұрын
In folder X, I have 2 excel files from column A to column H. Now I want to delete the unnecessary columns B: D, F, H in both excel files of the folder. How to write VBA code, so that when running the code, a message box will appear looking for the X directory address (or you can enter the X directory path directly into the code)
@juangabrieloc74993 жыл бұрын
Great content, thanks for sharing :)
@genessymendoza40663 жыл бұрын
Thank you 🙏 instructive
@Zues643 жыл бұрын
So i have one for you. I have a portfolio of dividend paying stocks. i would like a formula that would allow me to sift through my portfolio of data and find my top 10 highest dividend payers? I measure this by the highest yield percent of each stock in the portfolio. I need a function that will look at all the different stocks in my portfolio and return my top 10. thoughts please?
@HusseinKorish3 жыл бұрын
I like the video ... thumps up
@sahernossier47882 жыл бұрын
I was wondering if this can be done using app script. I mean to use filter method for each user so that when they trigger the filter function it won't affect other users.
@dansaleemdo78933 жыл бұрын
What is the best practical way if I want to filter a worksheet that has 100 names and create an individual filter for each name?
@panduanmicrosoftoffice-ind97943 жыл бұрын
I really like your tutorial. how amazing this tutorial with Google sheets.
@LeilaGharani3 жыл бұрын
Glad you like it!
@sriharim15963 жыл бұрын
Thanks for sharing... I feel this is same as Excel Sheet View
@LeilaGharani3 жыл бұрын
Yes, it is. It just seems a slower for me than GS.... at least when I was testing same data sets on both sides...
@aghatires1772 Жыл бұрын
Hello Leila, how can i make a search box in google sheets, in such a way that i can filter data once i write in the search box
@rodeolove Жыл бұрын
Can I share a google sheet with a college but filter their view (like in Sharepoint) I don't want them to see certain columns. Just 2 columns out of 10. I didn't want to create another sheet and have to key in the data twice.... Thoughts???
@JussimirPasold11 ай бұрын
Is it possible to remove or change the Filter View colors? I really don't like the dark grey borders
@geminievil2 жыл бұрын
Thank you!
@ayandapeter16812 жыл бұрын
Hi Leila, is it possible to use row level security in google sheets, or is it possible to restrict access to the views for editing and viewing, etc?
@RajendraPatel.3 жыл бұрын
Very helpful ❤️😁👍
@charlottestevenson31822 жыл бұрын
Hello, we use google sheets for all of our projects with filter view - however we have noticed that sometimes when you filter "department"/"project size"/"project manager" to analyse the project close data at the end of the quarter the data can get mixed up - is there a way of ensuring the row's are fixed you can freely filter knowing that the row data will not move/re-jig itself?
@andrewnicholls47182 жыл бұрын
Hi, is there anyway of disabling the delete filter view option? I have set up a number of views and people keep deleting them, thanks andrew
@undhaddipak3 жыл бұрын
ohhh very excellent video about filter most useful for me.and i request to you please make video regarding clean up and column stats.
@LeilaGharani3 жыл бұрын
Thank you and welcome! These new features are great. I will try next week to get Smart Fill in. Have already added the clean up and stats to future videos. Thank you.
@mcd226303 жыл бұрын
Haven't had a chance to watch the video. After hearing the news of the tragic event in Vienna, I hope you and those you care about have not been harmed.
@LeilaGharani3 жыл бұрын
It's really sad. Vienna was considered one of the safest cities in the world. We are safe. Thank you.
@adam346 Жыл бұрын
each "filter view" is like a virtual version of the sheet.. if multiple people use the same filter view, you are essentially working on the same sheet and if someone does something with that filter view, it will affect whomever is using the same view... we stumbled across this while trying to update customer lists in real time and multiple people were using the same filter view to try and work outside of the main list.
@5060northernmama2 жыл бұрын
Is there a Datasheet view available like works 9 had - you can pull up datasheet one by one, enter the data, and make less errors in the data entry.
@Econotrix2 жыл бұрын
Thanks a lot.
@usmaniqbal18363 жыл бұрын
Plz, Ms Liela, share this file... You are my favourite teacher
@morphinedrip49392 жыл бұрын
thank you so much :)
@JulianFernandez2 жыл бұрын
thanks so much.
@vincepeterson28343 жыл бұрын
Thank you
@danger_pig2 жыл бұрын
Can filters views hide/unhide columns?
@gajanandhumal88833 жыл бұрын
Big thank you..
@LeilaGharani3 жыл бұрын
Always welcome
@marleyshouseofsport90682 жыл бұрын
This is not really at all what you are explaining here.. but I hope it's okay to ask it anyway. I have a situation where I have a table, the data of which is being converted into a graph. Now I want people who view the page to only see the graph (the plotting of this data). But I still want to be able to alter that data with formulas etc in the usual way. Is there a method I can use that hides the table from the online page that people see while at the same time being able to see it myself in order to alter the data. (The closest I've come to this is to simply drag the graph straight on top of the table so people can't see it and then if I wish to alter anything simply move it away and back again.. this is pretty impractical though because I have to waste time moving the graph I just don't know how else to do it. )
@tanmoychatterjee70993 жыл бұрын
Great video Mam...I badly needed the information.. but you should give a practical example where one google sheet is used by multiple user and no one disturb the other' s sheet.. can you make a short video on that... because I have a bad experience some days ago in my office in working in google sheet by multiple user...all the valuable data almost gone because of erroneous use of google sheet by multiple user... please Mam..make a video specifically on that topic..🙏
@nitinyevale8427 Жыл бұрын
i am also facing the same problem....
@lancemorales83412 жыл бұрын
what if someone works in various departments? how do I assign multiple categories to an item
@sorenkarlesson57362 жыл бұрын
Tip: Use version control before filtering your data!!
@mohammadsamikhan53003 жыл бұрын
very nice.
@flipboutdatlife11323 жыл бұрын
I have a issue when I filter. A pop up used to come up saying see just mine or see everyone’s that option not longer pops up anyone to fix
@carolyap62122 жыл бұрын
i wish i can filter on the column view by hiding column that i don't need. Unfortunately, filter view not able to reach the goal. Hide unhide column not working in filter view.