Dear Friends,
My work involves using Data-Filter, very often. Is there any Key board Short cut for "Show All" function in Filter.
Waiting for your valuable reply.
with best wishes
Vinu
Dear Friends,
My work involves using Data-Filter, very often. Is there any Key board Short cut for "Show All" function in Filter.
Waiting for your valuable reply.
with best wishes
Vinu
In 2003 Alt+D then F and then F will remove autofilter and show all. Not sure about 2007 onwards off the top of my head.
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks