Go to last non-empty cell in column

[Fred Holmes]

What's an efficient way to go to either:

1. The last non-empty cell in a column, or
2. The empty cell below it?

Ctrl-down-arrow stops at every empty cell in the column. There are
lots of them.

A two step process would work:
1. go to the last cell in the column (row 65535)
2. Ctrl-Up-Arrow

But I don't know of an efficient way to do step one.

I'm sure I could write a VBA macro, but I'm looking for something
"universal" if possible.

Using Excel 2000

Many thanks,

Fred Holmes

 

[John]

HI Fred
Try Ctrl End
HTH
John

 

[Fred Holmes]

Ctrl-End is not what I'm looking for. It goes to the end (lower right
corner cell) of the active array (rectangual range encompassing all
non-empty, or merely explicitly-formatted cells), whether the end cell
is empty or not. The cell I'm looking for is in a particular column,
and may be many, many rows away from the last active row in the array
(where Ctrl-End takes me).
Thanks for trying. I guess I didn't explain myself thoroughly. I
need to go to the cell, in a specific column, for which all cells with
a higer Row # are empty.
Fred Holmes

 

[Suleman Peerzade]

Try
Crtl + down arrow
Ctrl + right arrow
Ctrl + left arrow
Ctrl + Up arrow

The cursor will stop if it finds a non blank cell or it will directly go to
the last cell in the sheet.
--
_______________________
Click "Yes" if it helps
________
Thanks
Suleman Peerzade

 

[Fred Holmes]

The below doesn't begin to do it. Ctrl-Down takes me to the next
empty cell. Ctrl-Right takes me to a column several columns to the
right. Ctrl-Left takes me to a column several columns to the left,
but not necessarily the column of interest. Ctrl-Up goes up in the
incorrect column.

I am in a cell somwhere in, say, Column C, which has lots of data in
it, but many cells in the data area are empty (because there is no
information for that field in in many records. I want to go directly
to the "end" of column C, efficiently. That's either the last
non-empty cell in column C or the empty cell below it.

Some columns contain formulae, e.g., the calculation of book balance
or bank balance in a check register, and these cells with the
appropriate formulae extend well below the "real" data area, so a
Ctrl-End takes me way too far down in the sheet.

Fred Holmes

 

[WBJ]

I too have wanted a more efficient way to do this -- but never found one.
What I do is <CTRL>-down arrow and hold it until I get to the bottom of the
spreadsheet. Then I <CTRL>-up and I'm right where I want to be. It's not the
best, but it works.

 

[excelent]

Sub last()
Cells(Rows.Count, ActiveCell.Column).End(xlUp).Select
End Sub

Add a shortcut like CTRL+l


"WBJ" skrev:

 

[Fred Holmes]

Here's a macro I wrote that does the trick -- since there doesn't seem
to be native commands to do it:

Sub GoTo_Last_Cell_in_Column()
Cells(65536, ActiveCell.Column).End(xlUp).Select
End Sub

Go to the bottom of the current column (Row 65535) and then do a
Ctrl-UpArrow to get to the last cell from there.

Fred Holmes

 

[Fred Holmes]

Exactly! Many thanks.

Fred Holmes

Sub last()
Cells(Rows.Count, ActiveCell.Column).End(xlUp).Select
End Sub

Add a shortcut like CTRL+l


"WBJ" skrev: