How to manage extra long columns?

[Guest]

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

 

[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

 

[Guest]

Please ignore this question! I keep clicking on the wrong newsgroup!
John

 

[Ken Snell [MVP]]

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

 

[Joseph Meehan]

Please ignore this question! I keep clicking on the wrong newsgroup!
John

You may have the right newsgroup. Your "problems" would not be problems
in Access. Of course there may be other parts of your application that does
not work well with Access.