I really enjoyed watching this video and recommend others to watch and learn. Host is an awesome teacher too. His voice and way of explaining I liked it and hope others will also like. Host explains clearly and crisply the subject matter. I watched many of his videos and all I liked and they enriched my knowledge on Excel. Thanks for educating the community and appreciate your volunteership. Thanks a bunch have a nice Thanksgiving day
Hi Kris, Thank you so much for the nice feedback. I really appreciate you sharing the videos. That helps me out a lot. Thanks again for your support and have a nice Thanksgiving as well. :-)
This is a very informative video... My question is how do I check and u check the items in the dropdown menu by using a short cut from the keyboard....
Very helpful video. But there is one problem in using some of shortcuts in Excel 2016. if I use the shortcut Alt,A,C to clear all filters, I am getting permenantely a message, that using of this shortcut is impossible. Is there any other shortcut for this function?
Hi Jon, Hopefully, you are doing well you have a great job with excel and I hope that we will get a lot unique to learn there The point to mail you was that I am too facing a problem in my excel sheet in filtering the data when I put the filter as my desire then the sum and grand total's row also go hide, so could you help me to solve this?
Thanks for your lecture. I'm facing a problem with using the filter along with using checkboxes, means I don't want my checkbox to reflected on hidden by filter, could you help please? Thanks
What is the shortcut to go directly on the last value on the the filter. How to scroll the down to the last value on the filter if there is a huge data set?
i have problem using vlookup it always give me ERROR #N/A in particular i am not able to understand how to give range in selected table if there is video on vlookup pls share link
Hi Hylda, Excel 2016 is the latest version of Excel. If you are using a Mac, I'm not sure that this shortcut works on the Mac version. If you are using a PC, then the data must be in an Excel Table for this to work.
I've been looking for the shortcut for getting to the search bar for ages! Thank you 😀
EXACTLY me too!
Excellent shortcuts for filtering Jon...especially hitting E to get into the search box which I didn't know. Thanks 👍
I have watched all three videos. All of them are so useful. My favourite is Shift + ALT + Down Arrow. Thanks
I really enjoyed watching this video and recommend others to watch and learn.
Host is an awesome teacher too. His voice and way of explaining I liked it and hope others will also like.
Host explains clearly and crisply the subject matter.
I watched many of his videos and all I liked and they enriched my knowledge on Excel.
Thanks for educating the community and appreciate your volunteership.
Thanks a bunch have a nice Thanksgiving day
Hi Kris,
Thank you so much for the nice feedback. I really appreciate you sharing the videos. That helps me out a lot. Thanks again for your support and have a nice Thanksgiving as well. :-)
@@ExcelCampus Using HP Chromebook where Alt+ down arrow shortcut is not working..please assist with the alternate shortcut pls
thanks for alt+down+e. Gonna definitely make my life easierrrrrrrr
Learned many shortcuts thanks jon
I love your videos - they are very well organized with great examples
This is a very informative video... My question is how do I check and u check the items in the dropdown menu by using a short cut from the keyboard....
Thank you so much..very helpful. I got what looking for..
Simple time saver indeed. Thank you
Thanks For This Good knowledge of Filter short keys of keyboard.this is nice video.
thumbs up dude for such an amazing content.
This is really helpful, Thank you!
You're welcome, @myfamily0170! 😀
will be using these shortcuts again and again thanks
This is so helpful. Thanks Jon!
Thank you very much
This was really helpful
Very helpful video. But there is one problem in using some of shortcuts in Excel 2016. if I use the shortcut Alt,A,C to clear all filters, I am getting permenantely a message, that using of this shortcut is impossible. Is there any other shortcut for this function?
So Clear your words to listen & Learn...
Thank u.....
Excellent. Thank you so much
Thank you so much sir 🙏🙏
Very detail , Thanks you so much
You're welcome! 😀
shift alt down arrow doesn't work for me (office 365) excel
Thanks a lot :). May GOD bless you.
Thank you! 😀
much much thanks
Great tutorial! Sooo helpful!
Best!!! Thanks a lot...
Thanks a lot
Hi Jon,
Hopefully, you are doing well
you have a great job with excel and I hope that we will get a lot unique to learn there
The point to mail you was that I am too facing a problem in my excel sheet in filtering the data when I put the filter as my desire then the sum and grand total's row also go hide, so could you help me to solve this?
Amazing!!!!
Bro .. Many Thanks
How about shortcut key to "unplus" when "date" column group by month
best comprehensive video Thanks
Thanks for your lecture.
I'm facing a problem with using the filter along with using checkboxes, means I don't want my checkbox to reflected on hidden by filter, could you help please?
Thanks
It is very helpful for us thank you
How we uncheck and check through keyboard in filter drop down without using mouse clicks.plz answer my question
Thanks, Awesome Video
Thank you Muhammad! :-)
Thanks a lot dada
Thanx, for explained.
hi sir.. I have one dout... when we apply the filter in excel sheet how to change text filter to date filter
Thank you.. Mr Jons
THANK YOU SIR. I mean it
Search options not showing in that fliter options
Life Saver like Always , Thanks :)
Thank you Romeo! :-)
in excel while excel filter function on date column how to open the + sign in data without using mouse
can you please tell me the shortcut for selecting all nos. except zeroes(o).
Perfect. Thanks!
If i have to select more then one in filter then how to select
What is the shortcut to go directly on the last value on the the filter. How to scroll the down to the last value on the filter if there is a huge data set?
You can use end button to go to last value & home button to come to select all
@@gellijayalakshmiharika2937 thankss
What is that XL campus and how it's created sir
lot's of tips and tricks!
I m unable to use short key (Crtl+shift+L) . as it is not working in my laptop
Blanks unselect from key board how ???? Plz
@3:21 yes, yes, yes!!!
i have problem using vlookup it always give me ERROR #N/A in particular i am not able to understand how to give range in selected table if there is video on vlookup pls share link
wonderful ❤❤
Amazing
Good
So much usefull
why can't i use shift+alt+down to filter from any cell in table?
Which version of Excel are you using? I'm not sure if this shortcut works on the Mac versions of Excel.
@@ExcelCampus mines a 2021 MS365
I am using Excel 2017, and Shift + Alt+↓ can't open the filter menu in any cell
Hi Hylda, Excel 2016 is the latest version of Excel. If you are using a Mac, I'm not sure that this shortcut works on the Mac version. If you are using a PC, then the data must be in an Excel Table for this to work.
jump to search press E owsam sir
owsam sir
nice sir tq
create an app in playstore sir.