Can't insert a new row

[skywaytraveler]

I have about 20 rows of data and I'm trying to insert a row of data
before line 6. I highlight cell 6, click Insert /Rows and then I get an
error, "To prevent the possible loss of data, Microsoft Excel cannot
shift nonblank cells off the work sheet."
It goes on with some more garbage, but it's already obvious that
Microsoft doesn't know what it's talking about. How do I get this
insert to work?
Thanks!

 

[Bob Phillips]

Take a look at these, you might find that MS does know what it is talking
about.

http://support.microsoft.com?kbid=170081
XL97: "Cannot Shift Objects Off Sheet" Error Hiding Columns

http://support.microsoft.com/default.aspx?kbid=211769
"Cannot shift objects off sheet" error message when you hide columns in
Excel

--

HTH

RP
(remove nothere from the email address if mailing direct)


"skywaytraveler"

 

[skywaytraveler]

Sorry, Bob. No help there.

 

[Debra Dalgleish]

What cell is selected when you press Ctrl + End?

Sorry, Bob. No help there.