Jump to content

Welcome to MSFN Forum
Register now to gain access to all of our features. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more. This message will be removed once you have signed in.
Login to Account Create an Account



Photo

How to make Excel 2007 keypress behaves like Excel 2003 ?

- - - - -

  • Please log in to reply
2 replies to this topic

#1
Joseph_sw

Joseph_sw

    Member

  • Member
  • PipPip
  • 217 posts
  • Joined 03-August 08
  • OS:98SE
  • Country: Country Flag
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 ?

Edited by Joseph_sw, 22 June 2012 - 07:08 PM.



How to remove advertisement from MSFN

#2
jaclaz

jaclaz

    The Finder

  • Developer
  • 14,580 posts
  • Joined 23-July 04
  • OS:none specified
  • Country: Country Flag
See if - by any chance :unsure: - 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 :ph34r: :
http://www.msfn.org/...ost__p__1000166

jaclaz

#3
Joseph_sw

Joseph_sw

    Member

  • Member
  • PipPip
  • 217 posts
  • Joined 03-August 08
  • OS:98SE
  • Country: Country Flag
ah, so thats where the settings are.
Unchecking it works.
Thanks.

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

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




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users