Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Skipping blanks
When I try to copy data and paste it without the blanks in between, I use the
paste special and check on the "skip blanks" box. However it does not work. Does anyone know how to accomplish this, or why it is not working? |
#2
|
|||
|
|||
Skip blanks does not remove the blanks. It just means that if you paste over
existing data, the blanks will not overwrite the existing cells. -- Ian -- "jmkona" wrote in message ... When I try to copy data and paste it without the blanks in between, I use the paste special and check on the "skip blanks" box. However it does not work. Does anyone know how to accomplish this, or why it is not working? |
#3
|
|||
|
|||
You could paste and then eliminate the blanks.
Select the pasted range edit|goto|special check blanks edit|delete shift cells up (or whatever you need) If this doesn't work because of surrounding data, you could insert a new worksheet, paste there, eliminate those blank cells and then copy this new range and paste. (Then delete the helper worksheet.) jmkona wrote: When I try to copy data and paste it without the blanks in between, I use the paste special and check on the "skip blanks" box. However it does not work. Does anyone know how to accomplish this, or why it is not working? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Weighed Average of a weiged average when there are blanks | Excel Discussion (Misc queries) | |||
Weighed average if the adjecent column contains blanks | Excel Discussion (Misc queries) | |||
linking files with blanks | Excel Discussion (Misc queries) | |||
Paste Special Skip Blanks not skipping blanks, but overwriting... | Excel Discussion (Misc queries) | |||
Filling in blanks. | Excel Worksheet Functions |