Dave,

Seems to me I once saw a way to do something along those lines, but here's
the best I could come up with now.

Start with a cell selected in the column to the left.

Press Ctrl-Down. Selects last cell in the column.
Press Right. Selects cell to right (bottom of desired selection
range).
Press Ctrl-Shift-Up. Selects from there up to the top of the worksheet.
Press Shift-Down Changes top extent of selection.

It's four steps. When you get the rhythm, make us a video. We'll put it to
music.
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Dave" wrote in message
...
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