Results 1 to 14 of 14
  1. #1
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    NJ, USA
    Posts
    239
    Thanks
    2
    Thanked 1 Time in 1 Post

    Keyboard shortcut to Unhide Columns

    I've always meant to ask: does anybody else find that the supposed shortcut key to unhide columns doesn't work for them? I mean Ctrl + Shift + ).
    I couldn't find any reference to a problem online anywhere, so suspected that an Add-In was the culprit. However, I just disabled them all but it still doesn't work for me.
    TIA

  2. #2
    5 Star Lounger
    Join Date
    Dec 2009
    Location
    East Coast, USA
    Posts
    993
    Thanks
    8
    Thanked 43 Times in 43 Posts
    That key combo works for unhiding columns in my Excel 2003.
    What version of Excel do you have?

    Can you unhide rows with Ctrl + Shift + (

  3. #3
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    Works for me to unhide columns within the selection. Does it work in Safe Mode?
    Regards,
    Rory

    Microsoft MVP - Excel

  4. #4
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    NJ, USA
    Posts
    239
    Thanks
    2
    Thanked 1 Time in 1 Post
    I'm using Excel 2007 - but it was the same for me in Excel 2003. Worked fine when I was using Excel 2000, though.
    The other related keyboard shortcuts all work fine: Ctrl + 0 to hide columns, Ctrl + 9 to hide rows, Ctr + Shift + ( to unhide rows. It's just the unhide columns that is the problem. I (temporarily) upgraded to Excel 2010 and found the same problem, so I guess it has to be my particular set-up somehow.
    My only add-ins are FindLink and Jan Karel's Name Manager...
    Thanks for the reply.

  5. #5
    5 Star Lounger
    Join Date
    Dec 2009
    Location
    East Coast, USA
    Posts
    993
    Thanks
    8
    Thanked 43 Times in 43 Posts
    If you open a new sheet and hide Column B
    Select cells in Columns A thru C and then Ctrl + Shift + )
    Will it unhide Col B ?

  6. #6
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,436
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    I tried this on all 3 of my machines as follows:
    Dell Inspiron Laptop Win-7 64 bit Excel 2007 32 Bit -- Did not work.
    Dell Inspiron 530 Desktop Win-7 64 bit Excel 2003 32 Bit -- Did not work.
    Dell 9100 Desktop XP SP-3 Excel 2003 -- Worked!!! For a minute there I thought it was a Dell Dude! However the Ctrl+Shift+( to hide the column did NOT work {on any of the three}...go figure
    BTW none of these have any addons. YMMV
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  7. #7
    5 Star Lounger
    Join Date
    Dec 2009
    Location
    East Coast, USA
    Posts
    993
    Thanks
    8
    Thanked 43 Times in 43 Posts
    Quote Originally Posted by RetiredGeek View Post
    However the Ctrl+Shift+( to hide the column did NOT work
    Hi RG -
    The Ctrl+Shift+( is used to unhide Rows not to "hide the column"

    I have attached a file created in Excel 2003 using Win XP Pro SP3.
    The Ctrl+Shift+) works to unhide columns
    The Ctrl+Shift+( works to unhide rows

    RG -Does that file work as expected in your versions (Win XP and Win7) of Excel 2003?
    It may fail on Win7 version of Excel 2003.

    Colin - Which version of Windows did you test in?
    Attached Files Attached Files

  8. #8
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    Colin,
    Did you test in Safe Mode? If so, I would guess you have some other program running that hooks that shortcut - there are utilities you can download to list shortcut keys in use in order to check.
    Regards,
    Rory

    Microsoft MVP - Excel

  9. #9
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,436
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Quote Originally Posted by tfspry View Post
    Hi RG -
    The Ctrl+Shift+( is used to unhide Rows not to "hide the column"

    I have attached a file created in Excel 2003 using Win XP Pro SP3.
    The Ctrl+Shift+) works to unhide columns
    The Ctrl+Shift+( works to unhide rows

    RG -Does that file work as expected in your versions (Win XP and Win7) of Excel 2003?
    It may fail on Win7 version of Excel 2003.

    Colin - Which version of Windows did you test in?
    Unhide ROWS works on all 3 machines!
    Unhide COLUMNS works on the XP SP-3 w/Excel 2003 SP-3 Machine but NOT on the two Win 7 64 Bit machines one w/2003 SP-3 & 1 with 2007 both 32 bit Excel. So is this a Win 7 problem?
    Last edited by RetiredGeek; 2011-05-13 at 09:19.
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  10. #10
    5 Star Lounger
    Join Date
    Dec 2009
    Location
    East Coast, USA
    Posts
    993
    Thanks
    8
    Thanked 43 Times in 43 Posts
    Well, this gets interesting! I tried a different machine running Win XP Pro SP3 that has both Excel 2002 and Excel 2010.
    The key combination of Ctrl+Shift+) works to unhide columns in both Excel 2002 and Excel 2010!
    The key combination will not work on my Win 7 with Excel 2010.

    I wonder what versions of Windows and Excel (in Post 3#) Rory used to get it to work for him?

  11. #11
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    I was testing 2003 and 2010 on Xp, but I just tested 2010 on Win7 64bit and it works there too.
    Regards,
    Rory

    Microsoft MVP - Excel

  12. #12
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,436
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Hey All,

    I just remembered that I had SharpKeys installed on both the Win-7 machines but not on the XP machine. I only use this to map the CapsLock key to the Left Shift key so I don't accidentally lock up the caps when I don't want caps...most of the time. Thinking this might be the problem I deleted the entry using SharpKeys; wrote the changes to the registry, and re-booted. No Love! This was not the problem.

    BTW: there are no other keys remapped!
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  13. #13
    5 Star Lounger
    Join Date
    Dec 2009
    Location
    East Coast, USA
    Posts
    993
    Thanks
    8
    Thanked 43 Times in 43 Posts
    For Win7, I am using Win7 Home Premium 32-bit.

    I was going to test this issue using Excel 2010 in Windows Safe Mode. I tried two versions of Safe Mode - plain old "Safe Mode" and "Safe Mode with Networking". I cannot get Excel 2010 to start in either Safe Mode. Looks like some sort of licensing error. I have legal copies of Office Home.

    pic of error message is attached....
    Attached Images Attached Images

  14. #14
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    NJ, USA
    Posts
    239
    Thanks
    2
    Thanked 1 Time in 1 Post
    I'm using Vista, but the problem first surfaced when I was on XP.
    Rory, I just tried starting in Safe Mode and the key combination still doesn't work. However, I think you have to be correct about some other program/process having hooked that shortcut key. I'll look for a utility that lists the shortcut keys in use, as you suggest, and post back if I find out anything.

Posting Permissions

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