Question:

Need help with microsoft office excel?

by  |  earlier

0 LIKES UnLike

i been using exel 2000 but now im using 2003 and the short cut keys are not the same.like with exel 2000 if u want to bring collum A2 and A3 to collum A1 the short cut key is ALT+E+S+T.Does anyone know how u do this in exel 2003 pls help....

 Tags:

   Report

2 ANSWERS


  1. Sounds like you want to move cell A2 to A1, and cell A3 to A2.  If thats the case, the easiest thing to do is right click in cell A1, select delete, and move cells up.  Much easier that 4 keys


  2. it sounds like you want to transpose.

    but copy&paste areas cant overlap in newer excels.

    so:

    - leave john out of this

    - copy from Williams down the column

    - click on B1

    - use Alt+E+S+E

    does that work for you?

    edit-

    i assume you did the usual copy, and then tried to right click, and for some wierd reason your paste special is not working?  your paste works, but paste special does not work?

    thats a little out of my league....sorry.

    you might want to ask a new question with the "paste" detail problems.  someone can probably figure it out.

Question Stats

Latest activity: earlier.
This question has 2 answers.

BECOME A GUIDE

Share your knowledge and help people by answering questions.