Alt Down Arrow Shortcut doesn't work when there are blank cells

T

Techy Wannabe

How come the Alt>Down 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.
 
G

Gord Dibben

Alt + Down Arrow opens the "Pick from drop down list"

I think you mean CTRL + Down Arrow and yes, it does stop at the first blank
cell.

How come? Cause that's the way it is.

Selecting cells in this manner has nothing in common with Data Validation that I
can think of.

To overcome the blank cells problem I use this macro to select the last cell in
a column.

Sub GODOWN()
Dim maxrow As Long
With ActiveCell.Parent.UsedRange
maxrow = .Cells(.Cells.Count).Row + 1
End With
ActiveCell.Parent.Cells(maxrow, ActiveCell.Column).End(xlUp).Select
End Sub


Gord Dibben MS Excel MVP
 
G

Guest

Hi, I apologize if I was not clear. I do want to pick from a drop down list
using Alt + Down Arrow.

It is just annoying that if a cell is blank within the column the drop down
does not retrieve the above info.

Thanks.
 
G

Guest

Hi, I want to keep my entries in a column uniform but have the ability to do
a hard entry. I sue the Alt + down arrow to see what I have previously
entered and choose from the list or enter the new term. If I skip one cell
then the drop down is empty. It will not show the entries above the blank
cell.

I hope this make more sense.
 
G

Gord Dibben

After a re-read I must admit that you were clearer in your description than I
was in my interpretation.

I agree that the "pick from list" blank cells limitation is not a great feature
but have no workaround for it other than a DV dropdown.

I would like the "pick from list" option extended to adjacent cells across rows
also but maybe next version.


Gord
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top