| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I delete all balnk cells in a column?
I would like to go into a column, or onto a page and delete all the blank
cells. Is there a quick way to do this? -- Thank you John |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I delete all balnk cells in a column?
John
To just delete the empty cells Select the range that has the empty cells gotoeditGo ToSpecialBlanksOk. Now either right click or edit on the tool bar and select "Delete", at the prompt select "shift cells up", and you are done. I hope you realize that by doing this you will disrupt any integrety the data may have. If there is no relationship with the data between the columns or rows, then this will work. Make a copy of your data first and see if it is REALLY what you want first. Mike Rogers "John" wrote: I would like to go into a column, or onto a page and delete all the blank cells. Is there a quick way to do this? -- Thank you John |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I delete all balnk cells in a column?
Mike, I appreciate your getting back to me, I suppose I should have stated
the blank cells are in between cells with inforamtion. I am trying to find a quick and easy way to highlight a range and delete only the blank cells that are above and below filled cells. I just want to an easy way to get rid of them without having to highligt every empty cell individually. If you know how please let me know. John -- Thank you John "Mike Rogers" wrote: John To just delete the empty cells Select the range that has the empty cells gotoeditGo ToSpecialBlanksOk. Now either right click or edit on the tool bar and select "Delete", at the prompt select "shift cells up", and you are done. I hope you realize that by doing this you will disrupt any integrety the data may have. If there is no relationship with the data between the columns or rows, then this will work. Make a copy of your data first and see if it is REALLY what you want first. Mike Rogers "John" wrote: I would like to go into a column, or onto a page and delete all the blank cells. Is there a quick way to do this? -- Thank you John |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I delete all balnk cells in a column?
John
Did you try my suggustion? It does what you asked. Mike Rogers "John" wrote: Mike, I appreciate your getting back to me, I suppose I should have stated the blank cells are in between cells with inforamtion. I am trying to find a quick and easy way to highlight a range and delete only the blank cells that are above and below filled cells. I just want to an easy way to get rid of them without having to highligt every empty cell individually. If you know how please let me know. John -- Thank you John "Mike Rogers" wrote: John To just delete the empty cells Select the range that has the empty cells gotoeditGo ToSpecialBlanksOk. Now either right click or edit on the tool bar and select "Delete", at the prompt select "shift cells up", and you are done. I hope you realize that by doing this you will disrupt any integrety the data may have. If there is no relationship with the data between the columns or rows, then this will work. Make a copy of your data first and see if it is REALLY what you want first. Mike Rogers "John" wrote: I would like to go into a column, or onto a page and delete all the blank cells. Is there a quick way to do this? -- Thank you John |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I delete all balnk cells in a column?
Do as Mike told you. That works fine.
Tyro "John" wrote in message ... Mike, I appreciate your getting back to me, I suppose I should have stated the blank cells are in between cells with inforamtion. I am trying to find a quick and easy way to highlight a range and delete only the blank cells that are above and below filled cells. I just want to an easy way to get rid of them without having to highligt every empty cell individually. If you know how please let me know. John -- Thank you John "Mike Rogers" wrote: John To just delete the empty cells Select the range that has the empty cells gotoeditGo ToSpecialBlanksOk. Now either right click or edit on the tool bar and select "Delete", at the prompt select "shift cells up", and you are done. I hope you realize that by doing this you will disrupt any integrety the data may have. If there is no relationship with the data between the columns or rows, then this will work. Make a copy of your data first and see if it is REALLY what you want first. Mike Rogers "John" wrote: I would like to go into a column, or onto a page and delete all the blank cells. Is there a quick way to do this? -- Thank you John |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I delete all balnk cells in a column?
Click and hold your mouse on the first cell in the range and drag it to the
last cell in the range, then right click and choose delete/move contents up. "John" wrote in message ... Mike, I appreciate your getting back to me, I suppose I should have stated the blank cells are in between cells with inforamtion. I am trying to find a quick and easy way to highlight a range and delete only the blank cells that are above and below filled cells. I just want to an easy way to get rid of them without having to highligt every empty cell individually. If you know how please let me know. John -- Thank you John "Mike Rogers" wrote: John To just delete the empty cells Select the range that has the empty cells gotoeditGo ToSpecialBlanksOk. Now either right click or edit on the tool bar and select "Delete", at the prompt select "shift cells up", and you are done. I hope you realize that by doing this you will disrupt any integrety the data may have. If there is no relationship with the data between the columns or rows, then this will work. Make a copy of your data first and see if it is REALLY what you want first. Mike Rogers "John" wrote: I would like to go into a column, or onto a page and delete all the blank cells. Is there a quick way to do this? -- Thank you John |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I delete all balnk cells in a column?
To just delete the empty cells Select the range that has the empty cells
gotoeditGo ToSpecialBlanksOk. An alternate to this is to select the range as above, then... Edit/Find/Find All (leave Find What blank)/Ctrl A/Close and then continue as below. Rick Now either right click or edit on the tool bar and select "Delete", at the prompt select "shift cells up", and you are done. I hope you realize that by doing this you will disrupt any integrety the data may have. If there is no relationship with the data between the columns or rows, then this will work. Make a copy of your data first and see if it is REALLY what you want first. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to delete all the blanc cells in a worksheet and shift cells l | Excel Discussion (Misc queries) | |||
| How can I copy information from one column, but not balnk cells? | Excel Discussion (Misc queries) | |||
| Easiest way to delete blank cells in column (not entire row) | Excel Discussion (Misc queries) | |||
| Code to delete rows and column cells that have formulas in. | Excel Worksheet Functions | |||
| In a column of text data, how do I delete random cells that have . | Excel Discussion (Misc queries) | |||
Linear Mode
