+ Reply to Thread
Results 1 to 5 of 5

CTRL Spacebar no longer works

  1. #1
    Registered User
    Join Date
    06-09-2008
    Posts
    3

    CTRL Spacebar no longer works

    Hi guys,

    I have a long history working with Excel and I have always relied on the keyboard shortcuts to zip through my heavy spreadsheet work.

    For some reason that I cannot fathom, the keyboard shortcut for highlight column, CTRL-Spacebar, no longer works. The shortcut for highlight row (SHIFT-Spacebar) works just fine.

    I have trawled the web for answers to my queries and the closest "I Don't Know" answer is here:

    http://groups.google.com.my/group/mi...f93f8e43915e66

    I have tried using the CTRL-Spacebar shortcut in safe mode but it is still not functioning.

    Do any of you know of any reasons why this should be happening? The closest answer I can think of is that another program is intercepting the CTRL-Spacebar keystrokes. However, I can't remember installing anything recently other than XP Service Pack 3.

    All help is definitely appreciated!

    PS: My Excel version is 2003
    Last edited by VBA Noob; 06-09-2008 at 07:47 AM.

  2. #2
    Forum Contributor
    Join Date
    01-05-2004
    Location
    Helsinki, Finland
    Posts
    100
    Hi,

    have you tried reseting the registry settings of Excel? You can do it with command line switches:

    excel /unregserver
    - Forces Excel to unregister itself and then quit.

    and

    excel /regserver
    - Forces Excel to register itself and then quit. Use this switch when you want Excel to rewrite all its registry keys and reassociate itself with Excel files, such as workbooks, charts, and others.

    - Asser

  3. #3
    Registered User
    Join Date
    06-09-2008
    Posts
    3
    Hi,

    Hmm...doesn't seem to work.

  4. #4
    Forum Contributor
    Join Date
    01-18-2005
    Location
    Auckland New Zealand
    MS-Off Ver
    Office Professional 2007
    Posts
    295
    I've found that this shortcut gets hijacked by the language bar, if you are inputting text in other languages. Is this the case here?

    Regards
    Mike

  5. #5
    Registered User
    Join Date
    06-09-2008
    Posts
    3
    I don't use the language bar at all. Tried launching it and closing it to make sure and zip results.

    The strange thing is that the other shortcuts using the CTRL key works. CTRL+SHIFT+Spacebar (highlight all cells) works.

    Argh!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1