Mrrrr's Forum (VIEW ONLY)
Un forum care ofera solutii pentru unele probleme legate in general de PC. Pe langa solutii, aici puteti gasi si alte lucruri interesante // A forum that offers solutions to some PC related issues. Besides these, here you can find more interesting stuff.
|
Nou pe simpatie:
sarmaluta2002 la Simpatie.ro
 | Femeie
24 ani
Bucuresti
cauta Barbat
25 - 50 ani |
|
|
Mrrrr's Forum (VIEW ONLY)ReguliInregistrareLoginPozeNu sunteti logat. Lista Forumurilor Pe Tematici
|
| #1 |
TRaPModerator
Postari: 964
|
|
The simplest way to do this is to right click on the cell containing the value you want to filter by, selecting Filter, then "Filter by selected cell's value".
Shortcut key combination to apply the filter is:
SHIFT+F10+E+V
SHIFT+F10 to open the right click menu
E to open the Filter section
V to apply the filter based on cell's value
If you have a normal keyboard instead of a laptop's keyboard, you might have the menu key embedded into the keyboard thus instead of SHIFT+F10 you would press just the menu key.
Shortcut key combination to clear the filter is:
SHIFT+F10+E+E
Source:
https://www.excelcampus.com/tips/filter ... -shortcut/
More keyboard shortcuts for working with filters:
https://www.excelcampus.com/keyboard-sh ... shortcuts/
|
|
| |
|
