PDA

View Full Version : In an excel sheet some column cells are blank then corresponding blank cell



aligahk06
05-10-2015, 06:46 PM
Dear All,

In an excel sheet some column cells are blank then corresponding blank cell entire should deleted.
for eg: column C cell c2 , c5, c7 ,c6 and so on are empty cell. I want to delete this particular empty cell deleted.

Any Idea.

Thanks,

Rgds,
aligahk06

Aussiebear
05-10-2015, 09:26 PM
In an excel sheet some column cells are blank then corresponding blank cell entire should deleted.


What makes a cell "corresponding"? Next cell, cells or row, and in which direction?


for eg: column C cell c2 , c5, c7 ,c6 and so on are empty cell. I want to delete this particular empty cell deleted.

From which direction does the cell get filled from? Are we shifting a group of cells?

As you can see we need more detail from you, and if possible a dummy workbook to work with to assist you.

aligahk06
05-10-2015, 10:34 PM
What makes a cell "corresponding"? Next cell, cells or row, and in which direction?From Top to down. Column verticalFrom which direction does the cell get filled from? Are we shifting a group of cells? As you can see we need more detail from you, and if possible a dummy workbook to work with to assist you.

vcoolio
05-11-2015, 03:09 AM
Hello Aussiebear,

A duplicate post perhaps? Have a look a couple of rows down from this one in the Excel forum list.

Cheerio,
vcoolio.