Archive of Mr Excel Message Board

Back to Edit in Excel archive index
Back to archive home

Copying cells and keeping the spacing between them

Posted by Nei Davidson on February 15, 2002 4:00 AM

I'm new to excel - a recent convert from quattro pro. I am trying to copy some cells - eg b1, b2, b4, b6, b7, b10, b15 etc and paste them into the same numerical cells on column c

When I do this it pushes all the values together in C1 throught to C7

Any ideas?

Neil

Re: Copying cells and keeping the spacing between them

Posted by Mark W. on February 15, 2002 10:03 AM

Select cells B1:C1 and then Control+Select...

B2:C2
B4:C4
B6:C6
B7:C7
B10:C10
B15:C15

...and the press Control+R or choose the
Edit | Fill Right menu command.

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.