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.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.