Hi Earl

If I copy one cell from somewhere in the sheet, I want to copy that one cell
to all the 10, 23, 40, 50 etc cells that are to the left which means I would
have to highlight those cells. Is there a way to paste what ever amount of
cell there is to the left.

Thanks in advance

Dave


"Earl Kiosterud" wrote in message
...
Dave,

When you paste, it pastes the amount of stuff you've copied. If you've
copied 10 vertical cells, that's what it's gonna paste. You need only
select the top-left-most cell before you do a paste.
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Dave" wrote in message
...
Hi All

If I have Data in cells A1 to A10
or C1 to C23 etc
and I want to paste more Data along side, to B1 to B10 or D1 to D23. Even
better would be if I could paste to either side of the data.
Is there away to do this without having to highlight those cells, this
would save me allot of time.

Thanks in Advance