| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
paste special
Hi,
I have a column of data with 4 blanks cells between each data. I just want to copy the data without any blank betwee. I did a paste special and I choose skip the blank but it doesnt work thanks Ade |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
paste special
Give this a try... Select the range. Hit F5 (or Ctrl+G or Edit - goto).
Select Constants or Formulas (depending on the nature of what you are copying). Only the populated cells should now be selected (assuming you do not have formulas returning blanks). Hit Ctrl+C to copy and then paste the cells in thir destination. -- HTH... Jim Thomlinson "adeline" wrote: Hi, I have a column of data with 4 blanks cells between each data. I just want to copy the data without any blank betwee. I did a paste special and I choose skip the blank but it doesnt work thanks Ade |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
paste special
Thank you so much; it works "adeline" wrote: Hi, I have a column of data with 4 blanks cells between each data. I just want to copy the data without any blank betwee. I did a paste special and I choose skip the blank but it doesnt work thanks Ade |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
paste special
Skip Blanks only prevents copied blank cells from overwriting existing data.
Not meant for deleting the blank cells when copying. See Jim's reply for workarounds. Why do you have the blank cells in the first place? Maybe you could get rid of them at source? Gord Dibben MS Excel MVP On Wed, 30 Jan 2008 13:59:04 -0800, adeline wrote: Hi, I have a column of data with 4 blanks cells between each data. I just want to copy the data without any blank betwee. I did a paste special and I choose skip the blank but it doesnt work thanks Ade |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't Copy and Paste or Paste Special between Excel Workbooks | Excel Discussion (Misc queries) | |||
| 'paste special', 'paste link' formatting transfer | Excel Discussion (Misc queries) | |||
| PASTE LINK option not available when I select PASTE SPECIAL to link an image in Excel to a Word document. | Links and Linking in Excel | |||
| In Excel: add a Paste-Special Option to paste IN REVERSE ORDER. | Excel Worksheet Functions | |||
| Paste and Paste Special command are not enabled in Excel | Excel Worksheet Functions | |||
Linear Mode
