Problems with long columns.
 

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

Use the control key in conjunction with Arrow down or
arrow right to get to the last used cell before the first
empty cell (if your data is uninterupted, this will be the
last row or column). Once you get there Ctrl+Shift+Arrow
Up or left will highlight the area for your paste.

You can also use the the Go to command (Ctrl+G) if you
know where your data ends.

-----Original Message-----
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

.

Thanks! I am sure this will do it.
Thanks for the help!
John

"Anon" wrote:

Use the control key in conjunction with Arrow down or
arrow right to get to the last used cell before the first
empty cell (if your data is uninterupted, this will be the
last row or column). Once you get there Ctrl+Shift+Arrow
Up or left will highlight the area for your paste.

You can also use the the Go to command (Ctrl+G) if you
know where your data ends.

-----Original Message-----
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

.

Ctrl End to get to the last cell & Ctrl Home to return

"JohnnyJomp" wrote:

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