is there a difference between ctrl-shift-down arrow and SHIFT + End +
Downarrow?

"bpeltzer" wrote:

Two alternatives I use with some frequency:
1) click the first cell, then ctrl-shift-down arrow. That will select a
continuous set of cells until finding an empty cell (or a continuous set of
empty cells until finding a non-empty, if your starting cell is empty)
2) if you have to do a lot of work with a huge list, split the screen a few
rows before the end. Get to the end of your table (just once), then go up a
few rows. Window Split. Click above the split and ctrl-home to get back
to the top. Then you can select an entire row by clicking on the first cell,
visible above the split and shift-clickink on the last cell, visible below
the split.
--Bruce

"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