ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

What is the keyboard shortcut to put the filter on data in Ms Excel 2010 ?

user-image
تم إضافة السؤال من قبل jhangeer bazmi , Freelance Graphics Designer
تاريخ النشر: 2017/03/09
Rahul Kohli
من قبل Rahul Kohli , Business Analyst , Nomura

Hello!

First select the data cell or cells you wish to apply filter on. Press CTRL+SHFT+L. This will activate filter option on that cell. Press drop down to select/filter your desired option.

Saddam Fareed
من قبل Saddam Fareed , Mid Level , Pakistan Oil Feild limited

The shortcut is Shift + F2

Saud Darwish Al Hajji
من قبل Saud Darwish Al Hajji , Finance Manager , Centena group

Ctrl+Shift+L......................

Ehtesham Ahmad
من قبل Ehtesham Ahmad , Graphic Designer , Nilorn India P.V.T.

Ctrl+Shift+L is the keyboard shortcut to turn the filters on/off. 

Doyere Coulibaly
من قبل Doyere Coulibaly , French Customer Representative , Mondelez International

the shortcut for the excel 2010 is Ctrl+Shift+L

Dhirajkumar Dhandhaliya
من قبل Dhirajkumar Dhandhaliya , Infrastructure Engineer , Mphasis Limited

Press Ctrl + Shift + L , it will direct apply filter on your courser row.  

NOUSHAD VARAMANGALATH
من قبل NOUSHAD VARAMANGALATH , Secretary Cum Document Controller , Saudi Diesel Equipment Co. Ltd

Press CTRL+T  and click OK for data range popup. 

A table range with filter will be created.

 

 

Firas Shahadi
من قبل Firas Shahadi , Human Resources Director , SAUDI UNION

the fasts way is to use Alt+A+T

that will active the filter on your data. 

المزيد من الأسئلة المماثلة