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.
|