Autoselecting Column Data - AutoFill

[roltman]

I import large quantities of data from text files and then perform operations on the columns. I am using version 1.1 on Linux.

I have spent a lot of hours trying to figure out how to:

1. Select a column from my current position (say A2) to the last data point (say A19332). Other programs perform this by double clicking the bottom of the input box while holding the shift key. Since the number of rows vary from file to file and are ~20k lines long this is highly desirable.

-- or --

2. AutoFill data down to the last data point. Say there is data from A2 - A19432 and I enter in B2 "=log(A2;2)". Is there a way to automagically fill this down to the last datapoint? In gnumeric you can do this by double clicking the little black box of the input box. Edit-Fill->Down works OK if I delete the column header and select the column, but it continues the formula past the last data point to row 32000.

Thanks,

-ryan

[dfrench]

1. select from current active cell down to bottom of filled cells

CTRL_SHIFT_DownArrow

2. to fill down, select as above then EDIT FILL DOWN

have a look at Help 'Shortcut Keys for Spreadsheets'

[roltman]

Works like a charm.

Thanks for the pointer on where to find these things in help.

-ryan