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.
Lista Forumurilor Pe Tematici
Mrrrr's Forum (VIEW ONLY) | Reguli | Inregistrare | Login

POZE MRRRR'S FORUM (VIEW ONLY)

Nu sunteti logat.
Nou pe simpatie:
Cezi Profile
Femeie
23 ani
Vaslui
cauta Barbat
27 - 80 ani
Mrrrr's Forum (VIEW ONLY) / Tutoriale si Ghiduri Utile // Tutorials and useful guides / [EXCEL] Filter Table by Cell Value Moderat de TRaP, TonyTzu
Autor
Mesaj Pagini: 1
TRaP
Moderator

Inregistrat: acum 6 ani
Postari: 739
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:

More keyboard shortcuts for working with filters:


pus acum 11 luni
   
Pagini: 1  

Mergi la