Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
EditGo ToSpecialBlanks
While working with EditGo ToSpecialBlanks, it captures Merged Cells as
blanks and deletes the values inside. Is there a way, we can control operation on Merged Cells. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
EditGo ToSpecialBlanks
I'm confused as to what you are doing. It appears you are selecting blank
cells and then, I'm guessing, hitting the Delete button (hence the "and deletes the values inside" part of your post). My question is... if the cells are already blank, why are you trying to delete their content? Perhaps if you give us a little more detail as to what you are trying to do, then maybe someone here will be able to come up with a solution for you. I will note that merged cells do contain blank cells within them and the Go To method you are using picks them up... I'm thinking you may need a VB solution to whatever it is you are actually trying to do in order to be able to avoid merges cells. Would that be an acceptable solution? If yes, then you will have to give us a clear idea of what you are trying to do so we can provide you with the code to do it. -- Rick (MVP - Excel) "Kshipra" wrote in message ... While working with EditGo ToSpecialBlanks, it captures Merged Cells as blanks and deletes the values inside. Is there a way, we can control operation on Merged Cells. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
EditGo ToSpecialBlanks
Welcome to the wonderful world of merged cells.
A workaround for this is to select only the entire column with the leftmost cell in the merge. Do not select the cells only. Assuming your merged cells encompass more than one column. Gord Dibben MS Excel MVP On Sun, 13 Sep 2009 09:39:01 -0700, Kshipra wrote: While working with EditGo ToSpecialBlanks, it captures Merged Cells as blanks and deletes the values inside. Is there a way, we can control operation on Merged Cells. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
EditGo ToSpecialBlanks
Hi Rick,
Thanks for your response. Let me explain, what I am trying to do. While we import data, or work on formatting cells, most of the time, we just select Column and apply Formats. With this, even Blank Cells get formatted and increases file size. What I am doing is finding all Blank Cells in worksheet at one go and deleting them. But in a way Merged Cells also get deleted, which is a real problem. Is there any way, I can control this. Regards, Aravinda "Rick Rothstein" wrote: I'm confused as to what you are doing. It appears you are selecting blank cells and then, I'm guessing, hitting the Delete button (hence the "and deletes the values inside" part of your post). My question is... if the cells are already blank, why are you trying to delete their content? Perhaps if you give us a little more detail as to what you are trying to do, then maybe someone here will be able to come up with a solution for you. I will note that merged cells do contain blank cells within them and the Go To method you are using picks them up... I'm thinking you may need a VB solution to whatever it is you are actually trying to do in order to be able to avoid merges cells. Would that be an acceptable solution? If yes, then you will have to give us a clear idea of what you are trying to do so we can provide you with the code to do it. -- Rick (MVP - Excel) "Kshipra" wrote in message ... While working with EditGo ToSpecialBlanks, it captures Merged Cells as blanks and deletes the values inside. Is there a way, we can control operation on Merged Cells. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
EditGo ToSpecialBlanks
I don't think formatting blank cells will increase the file size appreciably
but if you feel it does, why don't you select the blanks and simply clear the formatting rather than delete? Gord Dibben MS Excel MVP On Sun, 13 Sep 2009 21:57:01 -0700, Kshipra wrote: Hi Rick, Thanks for your response. Let me explain, what I am trying to do. While we import data, or work on formatting cells, most of the time, we just select Column and apply Formats. With this, even Blank Cells get formatted and increases file size. What I am doing is finding all Blank Cells in worksheet at one go and deleting them. But in a way Merged Cells also get deleted, which is a real problem. Is there any way, I can control this. Regards, Aravinda "Rick Rothstein" wrote: I'm confused as to what you are doing. It appears you are selecting blank cells and then, I'm guessing, hitting the Delete button (hence the "and deletes the values inside" part of your post). My question is... if the cells are already blank, why are you trying to delete their content? Perhaps if you give us a little more detail as to what you are trying to do, then maybe someone here will be able to come up with a solution for you. I will note that merged cells do contain blank cells within them and the Go To method you are using picks them up... I'm thinking you may need a VB solution to whatever it is you are actually trying to do in order to be able to avoid merges cells. Would that be an acceptable solution? If yes, then you will have to give us a clear idea of what you are trying to do so we can provide you with the code to do it. -- Rick (MVP - Excel) "Kshipra" wrote in message ... While working with EditGo ToSpecialBlanks, it captures Merged Cells as blanks and deletes the values inside. Is there a way, we can control operation on Merged Cells. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why does the skip blanks (paste special) function not work? | Excel Discussion (Misc queries) | |||
Paste Special as Values: no recognition of blanks | Excel Discussion (Misc queries) | |||
Paste Special - Skip Blanks | Excel Discussion (Misc queries) | |||
Paste Special Skip Blanks not skipping blanks, but overwriting... | Excel Discussion (Misc queries) | |||
Even after selecting "skip blanks" in the paste special menu in e. | Excel Discussion (Misc queries) |