cannot insert column due to non blank cell

**stevekirk** · 04-20-2008, 10:40 PM

hi,

i am trying to insert a column but i get an error message saying cannot remove non blank cell of the worksheet , i have done ctrl end and it takes me to IV 755 but there is nothing in it

thanks
steve

**Paul** · 04-20-2008, 10:43 PM

As a quick fix, if you're last column of data is in column Z, select columns AA through IV and click Edit -> Delete.

If that doesn't work, then perhaps there is an unseen object sitting in column IV somewhere..

**stevekirk** · 04-20-2008, 11:04 PM

hi,

thanks but that has not worked it still takes me to the same cell in column iv

steve

**Paul** · 04-20-2008, 11:10 PM

Any chance you could post a copy of the worksheet? You can even remove all of your other data if necessary before posting, as it's most likely irrelevant.

Thanks.

cannot insert column due to non blank cell

LinkBack

Thread Tools

Rate This Thread

Display

cannot insert column due to non blank cell

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions