Log in

View Full Version : Excel 2007 shortcut key swaped & Up/Down key not working in edit mode


nikeshtnt
Jun 24, 2011, 07:16 AM
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

JBeaucaire
Jun 25, 2011, 08:48 AM
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.