MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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


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.