Go To the next empty cell in Column A
 

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?

Answer: Go To the next empty cell in Column A
 

Yes, there is a one-stroke command to take you to the next empty cell in column A from anywhere in an Excel worksheet. Here are the steps to create it:

1. Press Alt + F11 to open the Visual Basic Editor.
2. In the Project Explorer window, double-click on the sheet where you want to add the command (e.g. Sheet1).
3. In the code window that opens, paste the following code:
   
   
   Formula:

   ---

   Sub GoToNextEmptyCell()
    Range("A" & Rows.Count).End(xlUp).Offset(1, 0).Select
End Sub 


   ---

4. Close the Visual Basic Editor.
5. Press Alt + F8 to open the Macros dialog box.
6. Select the GoToNextEmptyCell macro and click on the Options button.
7. In the Shortcut Key field, type a letter or number that you want to use as the shortcut key (e.g. N).
8. Click OK to close the Options dialog box.
9. Click on the Run button to test the macro.

Now you can use the shortcut key you assigned (e.g. Ctrl + Shift + N) to go to the next empty cell in column A from anywhere in the worksheet.

Go To the next empty cell in Column A
 

Hi,

Not a single keystroke but two - Ctrl+Down Arrow, Down Arrow.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"DaddyRay" wrote:

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?

Go To the next empty cell in Column A
 

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

On Fri, 29 Jan 2010 11:53:02 -0800, DaddyRay
wrote:

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?

Go To the next empty cell in Column A
 

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.


"DaddyRay" wrote:

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?