Copy/Pasting but keeping the blank cells.

[Eamonn100]

How can I copy/paste row 1 on to row 10 so that when it's pasted the blank cells/spaces are kept? Giving me a continuous line of numbers.

	a	b	c	d	e	f	g	h	i	j	k	l	m	n	o	p	q
1		1272	3562.3	140.61			0.207	-0.1	-0.026	-0.122	-0.821	-0.255				0.03
2
3
4
5
6
7
8
9
10	2658				875	6438							64	9463	6452		0.9784
example	2658	1272	3562.3	140.61	875	6438	0.207	-0.1	-0.026	-0.122	-0.821	-0.255	64	9463	6452	0.03	0.9784

<tbody>
</tbody>

 

[63falcondude]

You would have to use VBA for that. An alternative is to create a new row such as row 11 using a formula.

Excel 2010
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1		1272	3562.3	140.61			0.207	-0.1	-0.026	-0.122	-0.821	-0.255				0.03
2
3
4
5
6
7
8
9
10	2658				875	6438							64	9463	6452		0.9784
11	2658	1272	3562.3	140.61	875	6438	0.207	-0.1	-0.026	-0.122	-0.821	-0.255	64	9463	6452	0.03	0.9784
Sheet1

Cell Formulas
Range	Formula
A11	=SUMIF(A1:A10,"<>")

 

[Eamonn100]

Thanks.

Is there anyway to select/high light, with holding down control, B1, C1, D1, G1, H1, I1, J1, K1, L1,P1. Then copy/paste the normal way but with it keeping the spaces in between. Normal copy/pasting but with spaces?

Sorry but I don't no anything about VBA.

 

[63falcondude]

Thanks.

Is there anyway to select/high light, with holding down control, B1, C1, D1, G1, H1, I1, J1, K1, L1,P1. Then copy/paste the normal way but with it keeping the spaces in between. Normal copy/pasting but with spaces?

Sorry but I don't no anything about VBA.

Sure, simply highlight A1:Q1 and copy paste wherever you want it.

 

[Eamonn100]

Sorry, but I would need the empty cells not to blank out any info in cells they are being pasted over.

 

[63falcondude]

Sorry, but I would need the empty cells not to blank out any info in cells they are being pasted over.

I never knew this was possible without VBA. Apparently I was wrong... Try #7

http://www.techrepublic.com/blog/10-things/10-powerful-ways-to-use-excels-paste-features/

 

[Eamonn100]

Thanks for that. I was staring me in the face all along. I'm burnt out today, hahaha. That first formula will also be of help, thanks.

 

[63falcondude]

Thanks for that. I was staring me in the face all along. I'm burnt out today, hahaha. That first formula will also be of help, thanks.

Glad to help. I learned something new as well. Have a Merry Christmas!