View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David McRitchie David McRitchie is offline
external usenet poster
 
Posts: 903
Default Alt Down Arrow Shortcut doesn't work when there are blank cells

The shortcut Alt+Down is marked as pertaining
to a Filter. When I try it it only works on the cell
you use to select the filtering.
http://www.mvps.org/dmcritchie/excel/sortx2k.htm

What is it that you want to do?
---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Techy Wannabe" wrote in message oups.com...
How come the AltDown Arrow Shortcut doesn't work when there are blank
cells in the column?

Is there a way to direct the shortcut to look at the entire column
without doing data validation?

Thank you so very much.