How to manage extra long columns?

J

JohnnyJomp

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
 
R

Rick B

The newsgroup to which you posted your question is an Access newsgroup. We
answer questions about the database application MICROSOFT ACCESS. This
is not an Excel newsgroup.

You should probably get in the habit of looking at a few posts before you
add a new thread to a newsgroup. This newsgroup has nothing to do with your
question.

I'm betting if you search the appropriate newsgroup, or google, you might
even find an answer to your question without having to ask someone to repeat
it for you.

Rick B
 
K

Ken Snell [MVP]

You've posted your question to an ACCESS newsgroup. I recommend that you
post it to an EXCEL newsgroup.
 
Top