software

I want to delete the column B and column D in excel. But I dont want
that the cell to get shifted to left or right. i.e. after deleting the
column B and D, these columns should not get displayed in the excel
sheet at all.
Columns should be: Column A, Column C, Column E, Column F, Column G and
so on...

Thanks,
Reena--
reena
------------------------------------------------------------------------
reena's Profile: www.excelforum.com/member.php...oamp;userid=30440
View this thread: www.excelforum.com/showthread...hreadid=512538You cannot remove a column in excel, whatever you do it will be 256 columns
(excel 97 - 2003)
you can hide column B and column D but you can't make them disappear, if you
delete one another will take it's place

--
Regards,

Peo Sjoblom

Northwest Excel Solutions

Portland, Oregon

quot;reenaquot; gt; wrote in message
...
gt;
gt; I want to delete the column B and column D in excel. But I dont want
gt; that the cell to get shifted to left or right. i.e. after deleting the
gt; column B and D, these columns should not get displayed in the excel
gt; sheet at all.
gt; Columns should be: Column A, Column C, Column E, Column F, Column G and
gt; so on...
gt;
gt; Thanks,
gt; Reena
gt;
gt;
gt; --
gt; reena
gt; ------------------------------------------------------------------------
gt; reena's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30440
gt; View this thread: www.excelforum.com/showthread...hreadid=512538
gt;Think this is not possible.
Why not just try hiding the cols B and D instead ?
It'll achieve your intents
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
quot;reenaquot; gt; wrote in message
...
gt;
gt; I want to delete the column B and column D in excel. But I dont want
gt; that the cell to get shifted to left or right. i.e. after deleting the
gt; column B and D, these columns should not get displayed in the excel
gt; sheet at all.
gt; Columns should be: Column A, Column C, Column E, Column F, Column G and
gt; so on...
gt;
gt; Thanks,
gt; Reena
gt;
gt;
gt; --
gt; reena
gt; ------------------------------------------------------------------------
gt; reena's Profile:
www.excelforum.com/member.php...oamp;userid=30440
gt; View this thread: www.excelforum.com/showthread...hreadid=512538
gt;
Hi Reena,

Try hiding the columns:

Range(quot;B1, D1quot;).EntireColumn.Hidden = True

---
Regards,
Norman
quot;reenaquot; gt; wrote in message
...
gt;
gt; I want to delete the column B and column D in excel. But I dont want
gt; that the cell to get shifted to left or right. i.e. after deleting the
gt; column B and D, these columns should not get displayed in the excel
gt; sheet at all.
gt; Columns should be: Column A, Column C, Column E, Column F, Column G and
gt; so on...
gt;
gt; Thanks,
gt; Reena
gt;
gt;
gt; --
gt; reena
gt; ------------------------------------------------------------------------
gt; reena's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30440
gt; View this thread: www.excelforum.com/showthread...hreadid=512538
gt;
You may want to just empty the columns by selecting them and then hit
the quot;deletequot; key on your keyboard.

Hans