Thanks for your help David.
It worked and I finished the Inventory list I was creating.
Now I can't get it to print just the 1 page that I created. It is printing
pages of lines with no print, probably because it's printing the 65,000th
page. I've been trying to apply the same technique to erase the outside
columns but they won't delete.
I set the printer to just print page one but that didn't work.

I don't understand why Excel creates 65,000 rows to begin with. Is there a
way for Excel to just give you the amount of columns & rows that you need for
your document?

I put in a background color for some of my rows and they extended beyond my
document, but I tried to just hightlight the columns I wanted and it still
extended the color background on the entire row, past my document to
infinity. (it seems)

This inventory list is the final thing I need to accomplish to be rid of a
back-breaking business that I just sold. I just need to e-mail this document
as a printable page and then I can move on with my life. It seems like it
should be such a simple task but I've spent sooooo many hours on it.

I sure would appreciate your assistance to get past this point so I can
close the door on this issue and focus on my new future.
Excel, at first glance looks like a simple place to create docs with
columns. After reading thru many of the help issues, it appears that it can
do a whole lot more and it has turned into another confusing program. If you
have some basic tips on how to use it as a simple column and row doc., I
would love to hear your suggestions.

Up till now I've used Micrografix Draw to create everything from letters to
brochures. Unfortunately, Draw is limited on converting to a format that
others can read. But it seems to operate in a simple & logical fashion.
Microsoft programs like Word & Excel do things that are not expected or
logical, so my "learn thru experimental discovery" method has been very
unsuccessful so far. I'm just trying to create very basic one-time documents
to print and I'm spending days & nights on documents that a typewriter could
create in an hour.

"typewriter"---historic device that prints exactly what you tell it to. :o)

I sure hope that you can help me with this so I can move on, officially
close the door on this business and go back to being...
BarelyWild ;-)



"David McRitchie" wrote:

Hi "BarelyWild",

Don't know what it has to do with charts but it sounds like you
have something in the last column or last row of your worksheet
or are trying to insert a VERY large number of columns or rows
based on having most of your columns or rows selected before
trying to insert.

Use Ctrl+End to find your last cell (intersection of last used column and last used row).
who
You do not want to have hidden calculations on the worksheet in out
of the way places, especially near the edges of the worksheet as it
makes for very large files and for lots of problems in updating.

If Ctrl+End identifies your problem then use the recent response to an
entirely different question. (replied by Biff)
http://contextures.com/xlfaqApp.html#Unused
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Barelywild" wrote in message ...
How do I insert rows into the middle of my chart? When I right click insert,
or insert rows from the the top, I get the following message: "To prevent
possible loss of data, MS Excel cannot shift nonblank cells off the
worksheet........"

I don't understand the answers given on this subject previously.
I sure would appreciate a simple do this do that answer.
Thanks