MS Excel does not let me insert a column. It displays an error message thus-
To prevent possible loss of date, MS Excel cannot shift non-blank cells off
the work sheet.
What should I do to insert a new comumn?


----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

Had that problem a couple of times.

Try selecting all the blank columns to the right of your data and then
deleting them, sometime the blank cells might have a format on then.
Then try inserting your new column.

That's only worked for me a couple of times though.

the alternative is copy the data into a new workbook, that usually
works.


--
saybut
------------------------------------------------------------------------
saybut's Profile: http://www.excelforum.com/member.php...fo&userid=5949
View this thread: http://www.excelforum.com/showthread...hreadid=395826

XL: "Cannot Shift Objects Off Sheet" Error Hiding Columns
http://support.microsoft.com/default...b;en-ca;211769

Remember to look for comments and merged cells.

sharmila wrote:

MS Excel does not let me insert a column. It displays an error message thus-
To prevent possible loss of date, MS Excel cannot shift non-blank cells off
the work sheet.
What should I do to insert a new comumn?

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

--

Dave Peterson