Home |
Search |
Today's Posts |
#1
|
|||
|
|||
XL won't let me insert columns
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: "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." I've tried those things and they don't work. What does? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
XL won't let me insert columns
If you click <End<Home, in which column does your cursor end up?
"TROUBLE" 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: "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." I've tried those things and they don't work. What does? -- TROUBLE |
#3
|
|||
|
|||
If I press "home" on the keyboard, the box ends up in the "A" column coresponding to the row it was in. If I press "end" + "home", the cursor box goes to row 1955, column IT.
Quote:
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
XL won't let me insert columns
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 <End<Home again. If you have used all the columns up to IT, you cannot insert any more columns, I'm afraid! "TROUBLE" wrote: If I press "home" on the keyboard, the box ends up in the "A" column coresponding to the row it was in. If I press "end" + "home", the cursor box goes to row 1955, column IT. kassie Wrote: If you click EndHome, in which column does your cursor end up? "TROUBLE" 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: "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." I've tried those things and they don't work. What does? -- TROUBLE -- TROUBLE |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I insert multiple columns? | Excel Discussion (Misc queries) | |||
Adding columns w/new formulas BUT keeping subtotals | Excel Discussion (Misc queries) | |||
How do I wrap Excel columns in a printout? | Excel Discussion (Misc queries) | |||
Using VBA to insert Columns | Excel Worksheet Functions | |||
When sorting info in columns, can I make it insert blank line bet. | Excel Worksheet Functions |