Re: Error message when trying to insert a column

Yeah I'm going to go with lucky guess. We women are all nuts :)

"Doug Kanter" wrote:

> Internet Explorer may be a mess at times, but Excel, like a woman you've
> known for many years, is pretty easy to work with if you have any intuition
> at all. :-) Or, it was a lucky guess on my part.
>
> "Kelly" <Kelly@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:DC6F9D7E-3994-4D65-8C72-DC519BBBA855@xxxxxxxxxxxxxxxx
> > Hey Doug - Just tried deleting rows again (more than last time) and it
> > worked. Wo-hoo! thanks so much!!!
> >
> > "Doug Kanter" wrote:
> >
> >>
> >> "Kelly" <Kelly@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> >> news:DFC03239-6C60-4A54-925F-81DDA03FA877@xxxxxxxxxxxxxxxx
> >> > Hello -
> >> >
> >> > I'm in an Excel spread*** which I did not create. When I try
> >> > inserting
> >> > columns, I am getting the following error message: "to prevent
> >> > possible
> >> > loss
> >> > of data, Excel cannot shift nonblank cells off the work***. Try to
> >> > locate
> >> > the last nonblank cell by pressing CTRL+END and delete or clear all in
> >> > cells
> >> > between the last cell and the end of your data. Then select cell A1
> >> > and
> >> > save
> >> > your workbook to reset the last cell used. Or, you can move the data
> >> > to a
> >> > new location and try again". What on earth does this mean? I the
> >> > spread*** is not large but when I hit CTRL+END, I go to IV102. I
> >> > don't
> >> > know how to make this go away. Can anyone help, I would be most
> >> > grateful.
> >> > Thank you!
> >> >
> >> > Kelly
> >>
> >> It sounds to me like Excel thinks there is data living in the last
> >> column,
> >> all the way out to the right. Is there?
> >>
> >>
> >>
>
>
>
.