Copy & paste cells

  • Thread starter Thread starter Bobby
  • Start date Start date
B

Bobby

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.
 
Copy the cells you want, and then Edit -> Paste Special -> Transpose checkbox
in the bottom and click OK.
 
You did nothing wrong. That's how Transpose works.

See a reply at your other posting.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy & paste 1
data from multiple files: best way to extract 1
Need macro to move to first blank cell in column 6
Excel Data pastes into 2 cells not 1 1
I can't copy and paste equations 0
Macro to paste x number of times 4
Macro should copy & paste to various cells, but won't. 6
pasting content copied from nonadajacent cells 1

Back
Top