+ Reply to Thread
Results 1 to 6 of 6

CTRL+Spacebar not working to select entire column?

  1. #1
    Forum Contributor
    Join Date
    05-21-2014
    Location
    United States
    MS-Off Ver
    Office 2007 on Windows 7
    Posts
    119

    Question CTRL+Spacebar not working to select entire column?

    When I press CTRL+SPACEBAR, it does not select the entire column as it's supposed to.

    I found some info online that said it may have something to do with the Chinese language in my language bar. My language is set to EN, but when I click CTRL+SPACEBAR, it changes the language to Chinese.

    Anyone know how to fix this?

    Thank you in advance!

  2. #2
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: CTRL+Spacebar not working to select entire column?

    Right click the language bar, choose Settings, and have a look at the Advanced Key settings.
    Remember what the dormouse said
    Feed your head

  3. #3
    Forum Contributor
    Join Date
    05-21-2014
    Location
    United States
    MS-Off Ver
    Office 2007 on Windows 7
    Posts
    119

    Re: CTRL+Spacebar not working to select entire column?

    I tried that, and I changed the Switch Input Language and Switch Keyboard Layout both to Not Assigned then applied the changes, but it still seems to happen.

  4. #4
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: CTRL+Spacebar not working to select entire column?

    Which OS version?

    Have you tried removing Chinese from the installed languages?

  5. #5
    Forum Contributor
    Join Date
    05-21-2014
    Location
    United States
    MS-Off Ver
    Office 2007 on Windows 7
    Posts
    119

    Re: CTRL+Spacebar not working to select entire column?

    Sorry - Windows 7

  6. #6
    Registered User
    Join Date
    04-29-2021
    Location
    China
    MS-Off Ver
    Office 365
    Posts
    1

    Re: CTRL+Spacebar not working to select entire column?

    ctrl+space was used on my computer to change between Chinese and English. By disabling this function in the language setting, this shortcut now works. Thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Select entire column for max function
    By ssu95bm in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-02-2011, 10:36 AM
  2. Ctrl + Shift + Spacebar
    By Street3 in forum Excel General
    Replies: 3
    Last Post: 05-17-2010, 12:24 PM
  3. CTRL Spacebar no longer works
    By demosthenes in forum Excel General
    Replies: 4
    Last Post: 06-09-2008, 10:58 PM
  4. [SOLVED] Missing keyboard shortcut - CTRL+SPACEBAR
    By Ken in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-17-2005, 07:06 PM
  5. unable to use CTRL+spacebar in my laptop
    By Aditya in forum Excel General
    Replies: 1
    Last Post: 02-21-2005, 07:06 PM

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