Re: How to delete /clear the content of a column in Excel?

Formats

Discussions about working with different Open XML Formats

Details

3 Replies
0 Subscribers
Postedover 2 years ago

Options

SpreadsheetML

How to delete /clear the content of a column in Excel?

rated by 0 users
This post has 3 Replies |
0 Followers

Ottawa

Posted by Ottawa

on Mon, Mar 1 2010 12:22 PM

rated by 0 users
Post Points: 35
How to delete /clear the content of a column in Excel?

Hi,

Does anyone know how to delete or clear the content of a column in Excel using Open XML2.0 in VB.Net?

Thansk

gericuizon

Posted by gericuizon

on Sat, Mar 6 2010 1:21 AM

rated by 0 users
Post Points: 5
Re: How to delete /clear the content of a column in Excel?

try to highlight the corresponding column then right click then click delete...hope this helps

business articles online reviews funny stuff

Ankush Bhatia

490

Posted by Ankush Bhatia

on Thu, Mar 11 2010 5:21 PM

rated by 0 users
Post Points: 20
Re: How to delete /clear the content of a column in Excel?

Have a look at
http://ankushbhatia.wordpress.com/2010/03/11/basics-of-spreadsheet-how-to-clear-a-column-part-3/

HTH
Ankush

Frode M

Posted by Frode M

on Thu, Apr 8 2010 5:46 AM

rated by 0 users
Post Points: 5
Re: How to delete /clear the content of a column in Excel?

This works fine, but if you remove a column inside other columns, how would you move the cells right of the column deleted one column to the left? Frode