Did you get it?Įxcel is the most powerful tool to manage and analyze various types of Data.
Here, we have learned 5 essential shortcut keys on keyboard to master the Filter function.
#Activate excel short menu how to
Ĭlick here to see how to q uickly filter classified data in video tutorials, and here in graphic tutorials of WPS office Academy.Ĭlick here to master h ow to cancel filter in WPS SpreadsheetĬlick here to see our sp ecial features in AutoFilter. You are welcome to learn more about the filter function in WPS Academy. Use ↑ or ↓ (up or down arrow) to jump out of the editing box. Finally, press Enter to finish the filter process.Ģ. To check or uncheck items, press the Space bar.Ĥ. To choose items, use ↑ or ↓ (up or down arrow)ģ. Select a cell in the header, then press Alt+ ↓ (down arrow) to activate the Filter menu.Ģ. Check and uncheck items in the menu (Space bar)ġ. Press Alt+ ↓ (down arrow) to activate the Filter menu. Make sure that you have converted your data into a table and have turned the Filter on.Ģ.
Pressing Ctrl+Shift+L will help you turn Filters on or off. Make sure that you have converted your data into a table.Ģ. īy doing so, WPS will automatically generate a style for your table and filters for your headers. In the pop-up dialog, check My table has headers, then click OK.
To create filters, you can press the shortcut key Ctrl+L or Ctrl+T. Today will learn 5 useful shortcut key s. 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. When dealing with classified data in a table, the filter feature is often needed. 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.
0 kommentar(er)
