Is there a way to quickly filter on the active cell?
For example, if I have a list of names that has been autofiltered. Is there a shortcut key that will show me only those cells that contain the name in the active cell without having to go up to the filter and scroll down to find the relevant name?
thanks
For example, if I have a list of names that has been autofiltered. Is there a shortcut key that will show me only those cells that contain the name in the active cell without having to go up to the filter and scroll down to find the relevant name?
thanks