View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
[email protected] david.j.winfield@gmail.com is offline
external usenet poster
 
Posts: 25
Default another "to prevent possible loss of data, Microsoft Excel cannotshift nonblank cells off the worksheet."

On Feb 21, 4:14 pm, Ken Johnson wrote:
However, if I select the entire last column (or even the
last several columns) and right click on them and hit delete and
completely delete the entire column(s) I still get the message.


What if instead of right click delete you Edit|Clear All?

Ken Johnson


I do not see "Clear All" under the edit menu. However, if I right
click there is a "Clear Contents". I have tried this as well and I
still get the error.

I'm using Excel 2003