Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   Excel 2007 shortcut key swaped & Up/Down key not working in edit mode (https://www.askmehelpdesk.com/showthread.php?t=583780)

  • Jun 24, 2011, 07:16 AM
    nikeshtnt
    Excel 2007 shortcut key swaped & Up/Down key not working in edit mode
    Hi,

    Recently I started using excel 2007. From last week I am faceing following problem

    Problem No. 1
    Home and Ctr+Home have been swapped

    e.g. If I am in Cell D6 then by pressing Home I should go to A6 but now it takes me to A1 and if I press Ctr+Home then it should take me to A1 but actually taking to A6.

    Problem No. 2

    While editing long text in a cell (e.g. C7) which is Wrapped text and showing in 3 lines like this

    It should
    Be included
    With data

    Now if I want to edit it and press F2(in C7) then cursor rest at the end of text, now if I use upper key then it exits the edit mode and go to C6 and if press down key then it go to C8

    All the above problem is not in excel 2003 in my system.

    Please help


  • Jun 25, 2011, 08:48 AM
    JBeaucaire

    1) According to the published list of shortcut keys for 2007:

    HOME - Move to the beginning of the row.

    CTRL-HOME - Move to the beginning of the worksheet.



    2) While editing a cell, if pressing UP arrow causes the cell to exit, press F2 a second time before using the arrow keys.

  • All times are GMT -7. The time now is 11:03 AM.