I know how to copy and paste cells copy cells down then they past down "easy"
but can cells be copied down to up and then paste up? Copy cells 5-4-3-2-1 in
that order bottom cell to top cell then paste in cell #5 and have them paste
upwards? Just backwards of the normal way.
Thanks for any help
Bob

You can't doubleclick on the autofill button (bottom right corner of the
activecell), but you can drag that autofill button upwards.

If you rightclick and drag, you'll see a popup when you let go of the mouse.
You'll be able to choose the fill type that you want.

Bobby wrote:

I know how to copy and paste cells copy cells down then they past down "easy"
but can cells be copied down to up and then paste up? Copy cells 5-4-3-2-1 in
that order bottom cell to top cell then paste in cell #5 and have them paste
upwards? Just backwards of the normal way.
Thanks for any help
Bob

--

Dave Peterson

Copy the cells you want, and then Edit - Paste Special - Transpose checkbox
in the bottom and click OK.

"Bobby" wrote:

I know how to copy and paste cells copy cells down then they past down "easy"
but can cells be copied down to up and then paste up? Copy cells 5-4-3-2-1 in
that order bottom cell to top cell then paste in cell #5 and have them paste
upwards? Just backwards of the normal way.
Thanks for any help
Bob

Transposing paste the numbers in the wrong direction, I do something wrong?
Thanks

"Angela in Virginia" wrote:

Copy the cells you want, and then Edit - Paste Special - Transpose checkbox
in the bottom and click OK.

"Bobby" wrote:

I know how to copy and paste cells copy cells down then they past down "easy"
but can cells be copied down to up and then paste up? Copy cells 5-4-3-2-1 in
that order bottom cell to top cell then paste in cell #5 and have them paste
upwards? Just backwards of the normal way.
Thanks for any help
Bob

You did nothing wrong. That's how Transpose works.

See a reply at your other posting.


Gord Dibben MS Excel MVP

On Sat, 17 Jan 2009 09:15:01 -0800, Bobby wrote:

Transposing paste the numbers in the wrong direction, I do something wrong?
Thanks

"Angela in Virginia" wrote:

Copy the cells you want, and then Edit - Paste Special - Transpose checkbox
in the bottom and click OK.

"Bobby" wrote:

I know how to copy and paste cells copy cells down then they past down "easy"
but can cells be copied down to up and then paste up? Copy cells 5-4-3-2-1 in
that order bottom cell to top cell then paste in cell #5 and have them paste
upwards? Just backwards of the normal way.
Thanks for any help
Bob