how to copy cells which gaps exist between?

[Guest]

I need to copy cells with gaps between:
for example: a1 a3 a5 a7 and paste them with the gaps meaning that when i
paste them there will still be 1 cell apart, but i do not want to copy the
blank cells which exist in between.

thanks jared

 

[Excelenator]

Do you mean you want to copy the data on the left and paste it so it
looks like the data on the right? IF so you can highlight the entire
range on the left, press F5, select "Special" at the bottom of the
dialog box and click the radio button for "Constants" and then click
"OK". Right click on one of the selected cells and copy the data.
Select a destination cell and right click and select paste et voila!


Code:
--------------------
1 1
3
3 5
7
5 9

7

9

 

[Guest]

Actucally i will probably need to rephrase the question:

let say that the cells which exist are: a1,a2,a3,a4,a5,a6
the only ones which contain information are: a1,a3,a5
how do i copy them to a differenet location so that when i paste them into
b1. the cells which will contain information will be b1 b3 and b5 and not b1
b2 and b3


the tricky part is not copying the blank cells between.

jared

 

[Excelenator]

Are you trying to tell us that there is already data in cells b2,b4, and
b6 that you don't want disturbed? IF so you can do the following:


- Highlight the entire range of cells b1 through b6
- Click F5 and select "Special"
- Click the "Blanks" radio button
- Type in +A1 and hit CTL ENTER
- Highlight the range b1 through b6 again and click "Copy"
- Paste Special Values so that the formulas now become values

 

[Excelenator]

Are you trying to tell us that there is already data in cells b2,b4, and
b6 that you don't want disturbed? IF so you can do the following:


- Highlight the entire range of cells b1 through b6
- Click F5 and select "Special"
- Click the "Blanks" radio button
- Type in +A1 and hit CTL ENTER
- Highlight the range b1 through b6 again and click "Copy"
- Paste Special Values so that the formulas now become values

 

[Excelenator]

Are you trying to tell us that there is already data in cells b2,b4, and
b6 that you don't want disturbed? IF so you can do the following:


- Highlight the entire range of cells b1 through b6
- Click F5 and select "Special"
- Click the "Blanks" radio button
- Type in +A1 and hit CTL ENTER
- Highlight the range b1 through b6 again and click "Copy"
- Paste Special Values so that the formulas now become values

 

[Excelenator]

Are you trying to tell us that there is already data in cells b2,b4, and
b6 that you don't want disturbed? IF so you can do the following:


- Highlight the entire range of cells b1 through b6
- Click F5 and select "Special"
- Click the "Blanks" radio button
- Type in +A1 and hit CTL ENTER
- Highlight the range b1 through b6 again and click "Copy"
- Paste Special Values so that the formulas now become values

 

[Excelenator]

Are you trying to tell us that there is already data in cells b2,b4, and
b6 that you don't want disturbed? IF so you can do the following:


- Highlight the entire range of cells b1 through b6
- Click F5 and select "Special"
- Click the "Blanks" radio button
- Type in +A1 and hit CTL ENTER
- Highlight the range b1 through b6 again and click "Copy"
- Paste Special Values so that the formulas now become values

 

[Excelenator]

Are you trying to tell us that there is already data in cells b2,b4, and
b6 that you don't want disturbed? IF so you can do the following:


- Highlight the entire range of cells b1 through b6
- Click F5 and select "Special"
- Click the "Blanks" radio button
- Type in +A1 and hit CTL ENTER
- Highlight the range b1 through b6 again and click "Copy"
- Paste Special Values so that the formulas now become values

 

[Excelenator]

Are you trying to tell us that there is already data in cells b2,b4, and
b6 that you don't want disturbed? IF so you can do the following:


Highlight the entire range of cells b1 through b6
Click F5 and select "Special"
Click the "Blanks" radio button
Type in +A1 and hit CTL ENTER
Highlight the range b1 through b6 again and click "Copy"
Paste Special Values so that the formulas now become values

 

[Excelenator]

Are you trying to tell us that there is already data in cells b2,b4, and
b6 that you don't want disturbed? IF so you can do the following:


Highlight the entire range of cells b1 through b6
Click F5 and select "Special"
Click the "Blanks" radio button
Type in +A1 and hit CTL ENTER
Highlight the range b1 through b6 again and click "Copy"
Paste Special Values so that the formulas now become values