Go To the next empty cell in Column A

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?
 
G

Gord Dibben

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
 
A

Alojz

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.
 

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

Similar Threads

Copy corresponding cell in Column B if cell in A contains certain text? 1
Reference to next non-blank cell 5
How to concatenate cells that meets a specific criteria in threecolumns 6
Return to next row in first column when entering data in Excel 3
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
looking for formula to identify next non-empty cell on another sheet 10
How to copy data to the next empty cell in a column 2
Open workbook to same worksheet and next empty row 3

Top