WPS Office

Free All-in-One Office Suite with PDF Editor

correct-icon

Edit Word, Excel, and PPT for FREE.

correct-icon

Read, edit, and convert PDFs with the powerful PDF toolkit.

correct-icon

Microsoft-like interface, easy to use.

Free download

Windows • MacOS • Linux • iOS • Android

banner

Five must-have filter skills using keyboard in WPS Office Excel

July 31, 2023
10.9K Views

Are you ready to master how to filter data using keyboard in excel? After learning this WPS free course, you will be advanced from a beginner in WPS Spreadsheet.

When dealing with classified data in a table, the filter feature is often needed. Most people use the mouse to create and adjust the filter area, however, some shortcut keys on the keyboard can also achieve the same effect. Today will learn 5 useful shortcut keys.

· 1. Create filters (Ctrl+L or Ctrl+T)

To create filters, you can press the shortcut key Ctrl+L or Ctrl+T. In the pop-up dialog, check My table has headers, then click OK.

By doing so, WPS will automatically generate a style for your table and filters for your headers.

· 2.Turn Filters On or Off (Ctrl+Shift+L)

Make sure that you have converted your data into a table.

1. Select any cell in the table.

2. Pressing Ctrl+Shift+L will help you turn Filters on or off.

· 3. Activate the Filter menu (Alt + )

Make sure that you have converted your data into a table and have turned the Filter on.

1. Select a cell in the header.

2. Press Alt+(down arrow) to activate the Filter menu.

3.gif

· 4. Check and uncheck items in the menu (Space bar)

Make sure that you have converted your data into a table and have turned the Filter on.

1. Select a cell in the header, then press Alt+(down arrow) to activate the Filter menu.

2. To choose items, use or (up or down arrow)

3. To check or uncheck items, press the Space bar.

4. Finally, press Enter to finish the filter process.

· 5. Sort data in the menu (S or O)

Make sure that you have converted your data into a table and have turned the Filter on.

1. Select a cell in the header, then press Alt+(down arrow) to activate the Filter menu.

2. Use or (up or down arrow)  to jump out of the editing box. To sort in ascending order, press S. To sort in descending order, press O.

 5.gif

To explore more:

You are welcome to learn more about the filter function in WPS Academy.  

Click here to see how to quickly filter classified data in video tutorials, and here in graphic tutorials of WPS office Academy.

Click here to master how to cancel filter in WPS Spreadsheet

Click here to see our special features in AutoFilter.

Here, we have learned 5 essential shortcut keys on keyboard to master the Filter function. Did you get it?

Excel is the most powerful tool to manage and analyze various types of Data. This free WPS Spreadsheet tutorial for beginners covers in-depth lessons for Excel learning and how to use various Excel formulas, tables and charts for managing small to large scale business process.

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.