wow, thanks guys. Shift + end +downarrow is what i was looking for. In all my
lists, the first few rows are always headers of some sort. so i can't just
select the column.
thx

"Gord Dibben" wrote:

Tom

CTRL + a selects all cells.

SHIFT + End + Downarrow(or rightarrow) selects to first blank cell down or
across in active columns or rows.

See Help on "shortcut keys" for more selecting shortcuts.


Gord Dibben Excel MVP


On Mon, 31 Oct 2005 14:05:04 -0800, Tom wrote:

Haha, thx for the reply. However, I must correct myself... for a very long
list, is there a shortcut that doesn't require highlighting all the cells? or
maybe is there a shortcut to highlighting a range of cells without having to
drag the mouse? I'm asking this because i always scroll past the end of the
range. Very annoying trying to select long lists. It's like my scroll is on
hyperdrive.

Tom

"Gary''s Student" wrote:

In an un-used cell enter 1. Copy the cell and then paste/special with
multiply checked over all the cells you want to convert.
--
Gary's Student


"Tom" wrote:

I have a set of data that are numbers stored as text. CLicking on the little
green tab enables me to convert the text in the cell into a number. All The
data in the column starting from a certain row and ending at a certain row
are numbers stored as text. Also, it's a very long long long list. Is there a
shortcut to converting all the data to numbers without having to click the
green tab for each cell or having to highlight all the cells in the column
(only to zip past the last row) and go through cell properties?

Thanks