Results 1 to 7 of 7

Thread: Funny Excel keyboard shortcut

  1. Nov 23rd, 2012, 07:07 AM #1
    krtxmrtz
    krtxmrtz is offline

    Thread Starter
    vbuggy krtxmrtz's Avatar
    Join Date
    May 2002
    Location
    In a probability cloud
    Posts
    5,573

    Funny Excel keyboard shortcut

    I had an Excel spreadsheet and meant to hit ctrl+tab but hit ctrl+\ instead. Thereafter a number of changes occurred (the appearance changed, columns became larger, cells didn't respond to some format commands, formulas were considered text, etc) but undo was disabled. Anyone knows what that key combination is intended for and how to go back without having to exit without saving and starting Excel back?
    Lottery is a tax on people who are bad at maths
    If only mosquitoes sucked fat instead of blood...
    To do is to be (Descartes). To be is to do (Sartre). To be do be do (Sinatra)
    Reply With Quote Reply With Quote
  2. Nov 23rd, 2012, 08:48 AM #2
    4x2y
    4x2y is offline
    PowerPoster
    Join Date
    Sep 2006
    Location
    Egypt
    Posts
    2,579

    Re: Funny Excel keyboard shortcut

    I cannot find Ctrl+\ in the default Excel shortcuts http://office.microsoft.com/en-us/ex...001111659.aspx

    I think it is a shortcut for macro inside the spreadsheet as far as it do such many things!


    Reply With Quote Reply With Quote
  3. Nov 23rd, 2012, 09:46 AM #3
    krtxmrtz
    krtxmrtz is offline

    Thread Starter
    vbuggy krtxmrtz's Avatar
    Join Date
    May 2002
    Location
    In a probability cloud
    Posts
    5,573

    Re: Funny Excel keyboard shortcut

    Quote Originally Posted by 4x2y View Post
    I cannot find Ctrl+\ in the default Excel shortcuts http://office.microsoft.com/en-us/ex...001111659.aspx

    I think it is a shortcut for macro inside the spreadsheet as far as it do such many things!
    As a matter of fact, when you hit Alt \ again it reverts to the previous state so it works as a toggle switch, but I couldn't find any information either.
    Lottery is a tax on people who are bad at maths
    If only mosquitoes sucked fat instead of blood...
    To do is to be (Descartes). To be is to do (Sartre). To be do be do (Sinatra)
    Reply With Quote Reply With Quote
  4. Nov 23rd, 2012, 06:44 PM #4
    Nightwalker83
    Nightwalker83 is offline
    PowerPoster Nightwalker83's Avatar
    Join Date
    Dec 2001
    Location
    Adelaide, Australia
    Posts
    13,344

    Re: Funny Excel keyboard shortcut

    Quote Originally Posted by krtxmrtz View Post
    As a matter of fact, when you hit Alt \ again it reverts to the previous state so it works as a toggle switch, but I couldn't find any information either.
    Could you re-toggle the state afterwards so that the changes were back the the way they were back you hit the toggle switch?
    when you quote a post could you please do it via the "Reply With Quote" button or if it multiple post click the "''+" button then "Reply With Quote" button.
    If this thread is finished with please mark it "Resolved" by selecting "Mark thread resolved" from the "Thread tools" drop-down menu.
    https://get.cryptobrowser.site/30/4111672
    Reply With Quote Reply With Quote
  6. Nov 23rd, 2012, 11:08 PM #5
    Lord Orwell
    Lord Orwell is offline
    coder. Lord Orwell's Avatar
    Join Date
    Feb 2001
    Location
    Elberfeld, IN
    Posts
    7,628

    Re: Funny Excel keyboard shortcut

    there is one for the /. it's used for selecting array formula ranges. i don't know what \ does.
    My light show youtube page (it's made the news) www.youtube.com/@lightsofelberfeld
    Contact me on the socials www.facebook.com/lordorwell
    Reply With Quote Reply With Quote
  7. Nov 24th, 2012, 03:15 PM #6
    krtxmrtz
    krtxmrtz is offline

    Thread Starter
    vbuggy krtxmrtz's Avatar
    Join Date
    May 2002
    Location
    In a probability cloud
    Posts
    5,573

    Re: Funny Excel keyboard shortcut

    Quote Originally Posted by Nightwalker83 View Post
    Could you re-toggle the state afterwards so that the changes were back the the way they were back you hit the toggle switch?
    Yes but, if you make some changes after ctrl \ -say you modify the width of a column- then when you toggle back this width has not the original value.

    At any rate, try it out by yourself.

    I should mention however that I'm using a Spanish keyboard in which the \ character is in the top leftmost key unlike a US keyboard

    (see for instance: http://www.wesleyan.edu/CTWMellon/graphics/spankey.jpg)

    Name: spankey.jpg Views: 2498 Size: 70.5 KB
    Last edited by krtxmrtz; Nov 24th, 2012 at 03:20 PM.
    Lottery is a tax on people who are bad at maths
    If only mosquitoes sucked fat instead of blood...
    To do is to be (Descartes). To be is to do (Sartre). To be do be do (Sinatra)
    Reply With Quote Reply With Quote
  8. Nov 26th, 2012, 10:24 PM #7
    Lord Orwell
    Lord Orwell is offline
    coder. Lord Orwell's Avatar
    Join Date
    Feb 2001
    Location
    Elberfeld, IN
    Posts
    7,628

    Re: Funny Excel keyboard shortcut

    ah. i learned to program on that layout. took me forever to get used to the quotes placement when i got a pc.
    My light show youtube page (it's made the news) www.youtube.com/@lightsofelberfeld
    Contact me on the socials www.facebook.com/lordorwell
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width