Copy/Pasting but keeping the blank cells.

Eamonn100

Board Regular
Joined
Nov 12, 2015
Messages
156
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.

abcdefghijklmnopq
112723562.3140.610.207-0.1-0.026-0.122-0.821-0.2550.03
2
3
4
5
6
7
8
9
102658875643864946364520.9784
example265812723562.3140.6187564380.207-0.1-0.026-0.122-0.821-0.25564946364520.030.9784

<tbody>
</tbody>
 

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

63falcondude

Well-known Member
Joined
Jan 15, 2016
Messages
3,572
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
ABCDEFGHIJKLMNOPQ
112723562.3140.610.207-0.1-0.026-0.122-0.821-0.2550.03
2
3
4
5
6
7
8
9
102658875643864946364520.9784
11265812723562.3140.6187564380.207-0.1-0.026-0.122-0.821-0.25564946364520.030.9784
Sheet1
Cell Formulas
RangeFormula
A11=SUMIF(A1:A10,"<>")
 
Upvote 0

Eamonn100

Board Regular
Joined
Nov 12, 2015
Messages
156
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.
 
Upvote 0

63falcondude

Well-known Member
Joined
Jan 15, 2016
Messages
3,572
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.
 
Upvote 0

Eamonn100

Board Regular
Joined
Nov 12, 2015
Messages
156
ADVERTISEMENT
Sorry, but I would need the empty cells not to blank out any info in cells they are being pasted over.
 
Upvote 0

Eamonn100

Board Regular
Joined
Nov 12, 2015
Messages
156
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.
 
Upvote 0

Forum statistics

Threads
1,195,674
Messages
6,011,096
Members
441,582
Latest member
Topkapi

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top