MS EXCEL does not let me insert a column

[sharmila]

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

[saybut]

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.

[Dave Peterson]

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