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

January 21, 2022
3.1K Views
0

A free Office suite fully compatible with Microsoft Office

Free Download

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.

· 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.

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.