[Joseph_sw]

a few days ago i was forced to work with Excel 2007, and i found some annoyances.


Problem example:

I fill a math matrix starting from cell C3 to L12.
I want to select that matrix.

Under Excel 2003 or earlier verison:

• I go to C3
  
• I press & hold {Shift}+{Ctrl}
  
• I press {Down}
  
• I press {Right}
  
• Release the {Shift}+{Ctrl}

Selection completed.

However the whole idea of pressing & hold {Shift}+{Ctrl} then press {Down} or {Right} were failed in Excel 2007.
So, under Excel 2007, i must do it like the old Lotus 1-2-3 way:

• I go to C3
  
• I press & hold {Shift}
  
• I press {End}
  
• I press {Down}
  
• I press {End}
  
• I press {Right}
  
• I release the {Shift}

Selection completed

from 5 steps in earlier excel become 7 steps in excel 2007,
in this matter excel 2007 were about 20% LESS efficient than excel 2003 !!

Thats not what my typing reflects has been trained for.


Is there any settings on excel 2007 to make the keypress behaves like excel 2003 or earlier ?

This post has been edited by Joseph_sw: 22 June 2012 - 07:08 PM

[jaclaz]

See if - by any chance - it is connected with settings of the "section":
"Lotus Compatibility Settings for:"
http://www.pcreview....a-t3560251.html

JFYI, it really seems like Excel 2007 is a bettered Excel 2000, only worse :
http://www.msfn.org/...ost__p__1000166

jaclaz

[Joseph_sw]

ah, so thats where the settings are.
Unchecking it works.
Thanks.

Quote

JFYI, it really seems like Excel 2007 is a bettered Excel 2000, only worse

yeah, i also dislike 2007 the moment i see it.