Hi all...
My spreadsheets are farly simple, but I have a problem. When I copy a
formula all the way down a column, it creates spreadsheets that are thousands
of rows long. Is there a way to paste the formulae only until the bottom of
the used area? for example, I have nothing after 800, but choosing an column
and pasting a formula will extend the spreadsheet to0 row 8000 or more.

In a related vein, how do I jump to the bottom of a spreadsheet. Once I have
pasted the formula, the columns are so long that using the scroll bar is not
an option.

Thanks for any tips!
John