Go To the next empty cell in Column A

  • Thread starter Thread starter DaddyRay
  • Start date Start date
D

DaddyRay

Using Vista and Excel 2007, I will be constructing a mailing list with 10
columns. In the first empty row of column A will be added a new name for the
list. With 10 columns it is not possible to view Column A from Column L on
screen. With hundreds of names to add to the list, I need a fast way to go
to the next empty cell in column A to add the next name..
I am familiar with tables in Access where there is an icon that will take me
to the next empty cell in column A. Is there a similar one stroke command to
take me to the next empty cell in column A from anywhere in an Excel
worksheet?
Or can you help me create a one stroke command to do this?
 
If you are entering a name in A the then moving across to L adding other
data as you go................

Type the name in A then Tab to next cell, type in data then Tab to next
cell.

When you reach L enter the data and hit ENTER key.

You will be taken back to A at next row down.


Gord Dibben MS Excel MVP
 
Either click in any cell in column A which is not empty. Press end and down
arrow. Or else: ctrl + end, home, down arrow. Several other options would
work, too.
 
Back
Top