Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

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

user-image
Question ajoutée par jhangeer bazmi , Freelance Graphics Designer
Date de publication: 2017/03/09
Rahul Kohli
par 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
par Saddam Fareed , Mid Level , Pakistan Oil Feild limited

The shortcut is Shift + F2

Saud Darwish Al Hajji
par Saud Darwish Al Hajji , Finance Manager , Centena group

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

Press Ctrl+Shift+L to apply the filters.

Ehtesham Ahmad
par Ehtesham Ahmad , Graphic Designer , Nilorn India P.V.T.

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

Doyere Coulibaly
par Doyere Coulibaly , French Customer Representative , Mondelez International

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

Dhirajkumar Dhandhaliya
par Dhirajkumar Dhandhaliya , Infrastructure Engineer , Mphasis Limited

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

NOUSHAD VARAMANGALATH
par 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
par Firas Shahadi , Human Resources Director , SAUDI UNION

the fasts way is to use Alt+A+T

that will active the filter on your data. 

More Questions Like This