Excel Limitation - Inserting Colums - Help

[Guest]

Having difficulties inserting columes into a document.

Error received
To prevent possible loss of data non blank cells , Microsoft Excel cannot
shift non blank cells off the worksheet.

Any siggestions.

many thanks

Tim

 

[JulieD]

Hi Tim

it sounds like a cell somewhere has got a space in it .. press CONTROL & END
and see where you go ... then i would recommend deleting all the columns
from your last real entry to that entry & same with the rows and then
closing & saving the workbook. When you reopen it it should work fine ...
check out
http://www.contextures.com/xlfaqApp.html#unused
for more details