Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting a column
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: http://www.excelforum.com/member.php...o&userid=30440 View this thread: http://www.excelforum.com/showthread...hreadid=512538 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting a column
You 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 "reena" wrote in message ... 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: http://www.excelforum.com/member.php...o&userid=30440 View this thread: http://www.excelforum.com/showthread...hreadid=512538 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting a column
Think this is not possible.
Why not just try hiding the cols B and D instead ? It'll achieve your intents -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "reena" wrote in message ... 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: http://www.excelforum.com/member.php...o&userid=30440 View this thread: http://www.excelforum.com/showthread...hreadid=512538 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting a column
Hi Reena,
Try hiding the columns: Range("B1, D1").EntireColumn.Hidden = True --- Regards, Norman "reena" wrote in message ... 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: http://www.excelforum.com/member.php...o&userid=30440 View this thread: http://www.excelforum.com/showthread...hreadid=512538 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting a column
You may want to just empty the columns by selecting them and then hit
the "delete" key on your keyboard. Hans |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
IF/AND/OR/DATEIF Issue...sorry...long post... | Excel Worksheet Functions | |||
creating a bar graph | Excel Discussion (Misc queries) | |||
Deleting specific records from a column | Excel Discussion (Misc queries) | |||
How can I sort an entire spreadsheet from a list | Excel Worksheet Functions |