software

I'm trying to insert columns into a spread sheet. It lets me insert 2. From then on it won't let me insert any more.
It says: quot;to prevent loss of data, Microsoft Excel cannot shift nonblank cells off the worksheet. Try to delete or clear the cells to the right and below your data. then select A1, and save your workbook to reset the last cell used. Or you can move the data to a new location and try again.quot; I've tried those things and they don't work.

What does?
If you click lt;Endgt;lt;Homegt;, in which column does your cursor end up?

quot;TROUBLEquot; wrote:

gt;
gt; I'm trying to insert columns into a spread sheet. It lets me insert 2.
gt; From then on it won't let me insert any more.
gt; It says: quot;to prevent loss of data, Microsoft Excel cannot shift
gt; nonblank cells off the worksheet. Try to delete or clear the cells to
gt; the right and below your data. then select A1, and save your workbook
gt; to reset the last cell used. Or you can move the data to a new
gt; location and try again.quot; I've tried those things and they don't work.
gt;
gt;
gt; What does?
gt;
gt;
gt; --
gt; TROUBLE
gt;

If I press quot;homequot; on the keyboard, the box ends up in the quot;Aquot; column coresponding to the row it was in. If I press quot;endquot; quot;homequot;, the cursor box goes to row 1955, column IT.

Originally Posted by kassieIf you click EndHome, in which column does your cursor end up?

quot;TROUBLEquot; wrote:

I'm trying to insert columns into a spread sheet. It lets me insert 2.From then on it won't let me insert any more.It says: quot;to prevent loss of data, Microsoft Excel cannot shiftnonblank cells off the worksheet. Try to delete or clear the cells tothe right and below your data. then select A1, and save your workbookto reset the last cell used. Or you can move the data to a newlocation and try again.quot; I've tried those things and they don't work.

What does?

--TROUBLE
Since column IV is the last one in the sheet, small wonder you are getting
this message! Are you using all the columns from A to IT, and all the rows
from 1 to 1955? If not, then go to the last cell you have actually used, say
for example AG1058, delete all the columns to the right of that, and all the
rows below that. save your file and press lt;Endgt;lt;Homegt; again. If you have
used all the columns up to IT, you cannot insert any more columns, I'm afraid!

quot;TROUBLEquot; wrote:

gt;
gt; If I press quot;homequot; on the keyboard, the box ends up in the quot;Aquot; column
gt; coresponding to the row it was in. If I press quot;endquot; quot;homequot;, the
gt; cursor box goes to row 1955, column IT.
gt;
gt;
gt;
gt; kassie Wrote:
gt; gt; If you click EndHome, in which column does your cursor end up?
gt; gt;
gt; gt; quot;TROUBLEquot; wrote:
gt; gt;
gt; gt;
gt; gt; I'm trying to insert columns into a spread sheet. It lets me insert
gt; gt; 2.
gt; gt; From then on it won't let me insert any more.
gt; gt; It says: quot;to prevent loss of data, Microsoft Excel cannot shift
gt; gt; nonblank cells off the worksheet. Try to delete or clear the cells
gt; gt; to
gt; gt; the right and below your data. then select A1, and save your
gt; gt; workbook
gt; gt; to reset the last cell used. Or you can move the data to a new
gt; gt; location and try again.quot; I've tried those things and they don't
gt; gt; work.
gt; gt;
gt; gt;
gt; gt; What does?
gt; gt;
gt; gt;
gt; gt; --
gt; gt; TROUBLE
gt; gt;
gt;
gt;
gt; --
gt; TROUBLE
gt;