Joseph_sw Posted June 23, 2012 Share Posted June 23, 2012 (edited) 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 C3I 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 C3I press & hold {Shift}I press {End}I press {Down}I press {End}I press {Right}I release the {Shift}Selection completedfrom 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 ? Edited June 23, 2012 by Joseph_sw Link to comment Share on other sites More sharing options...
jaclaz Posted June 23, 2012 Share Posted June 23, 2012 See if - by any chance - it is connected with settings of the "section":"Lotus Compatibility Settings for:"http://www.pcreview.co.uk/forums/excel-2003-array-formula-excel-2007-a-t3560251.htmlJFYI, it really seems like Excel 2007 is a bettered Excel 2000, only worse :jaclaz Link to comment Share on other sites More sharing options...
Joseph_sw Posted June 23, 2012 Author Share Posted June 23, 2012 ah, so thats where the settings are.Unchecking it works.Thanks.JFYI' date=' it really seems like Excel 2007 is a bettered Excel 2000, only worse[/quote']yeah, i also dislike 2007 the moment i see it. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now