Bayt.com

Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

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

Microsoft tools Office Work Microsoft Excel MS Office tools
user-image
Question added by jhangeer bazmi , Freelance Graphics Designer
Date Posted: 2017/03/09
Upvote (0) Views (35) Followers (9) Answers (9) Report Question
Write an Answer
Register now or log in to answer.
Rahul Kohli
by 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
by Saddam Fareed , Mid Level , Pakistan Oil Feild limited

The shortcut is Shift + F2

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

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

Mark Aguilar

Press Ctrl+Shift+L to apply the filters.

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

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

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

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

Dhirajkumar Dhandhaliya
by Dhirajkumar Dhandhaliya , Infrastructure Engineer , Mphasis Limited

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

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

the fasts way is to use Alt+A+T

that will active the filter on your data. 

Write Your Answer
More Questions Like This