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 , Computer Instructor and Operator , Imran Computer College Millat Chowk
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 , Assistant 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 , Training And Development Director , Muhayal Assir National Hospital

the fasts way is to use Alt+A+T

that will active the filter on your data. 

Write Your Answer
More Questions Like This

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.

Get Help