Insert Row-First time user

[Guest]

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

 

[David McRitchie]

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).

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

 

[Guest]

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. )

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]

Hi "BarelyWild",
You don't need to actually print to see if you have a problem
use the Print Preview.

The PrintArea limits the print area it does not extend it, so all
256 columns (columns.count) can be included.

If I understand correctly you ran the DeleteUnused macro at
http://contextures.com/xlfaqApp.html#Unused
it worked you printed, and now you have the same problem.
Then wouldn't you try the same solution again, of course it
would be helpful to identify the cause of the problem...

If it did not work, check your lastcell, Ctrl+End if that is
beyond your data after running the above macro you have
cells that are not empty (cells with formulas or spaces) and
whatever you are doing to create them, I'd be a bit suspicious
of the rows you formatted (you said some rows) sounds like
you copied rows with spaces down using the fill handle.
Try using the formatting tool instead.. Or copy (ctrl+c),
then paste special, formatting. (and only formatting).
..
In the meantime you can select a cell that is to be your last
cell and run the makelastcell macro which will only
apply to your active worksheet.
Making the activecell the LastCell (#MakeLastCell)
http://www.mvps.org/dmcritchie/excel/lastcell.htm#MakeLastCell

Once you have made your changes -- save the workbook to make sure
that you have saved your changes.

Some Things That Waste Space in Spreadsheets (#waste)
http://www.mvps.org/dmcritchie/excel/lastcell.htm#waste

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.

Printer or print area, if printer maker sure the radio button is pressed
and not just the number of pages.