Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hello -
I'm in an Excel spreadsheet 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 worksheet. 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 spreadsheet 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Arithmetical Mode of Criteria in Multiple Non-Adjacent columns | Excel Worksheet Functions | |||
Lookup Table Dilemma | Excel Worksheet Functions | |||
how do i insert words into a column without erasing the words | Excel Discussion (Misc queries) | |||
Lookup then Match and insert value from next column | Excel Worksheet Functions | |||
How can I sort an entire spreadsheet from a list | Excel Worksheet Functions |