View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Fred Holmes Fred Holmes is offline
external usenet poster
 
Posts: 112
Default Go to last non-empty cell in column

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

On Thu, 22 Jan 2009 04:00:03 -0800, Suleman Peerzade
wrote:

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.