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.
